Inspiration

I want to use Airtable to power a curated newsletter workflow. From searching for news articles, curating the best links and then creating a newsletter. This block is covering the first step of the workflow

What it does

This blocks uses Bing News Search API to search the web for news articles, then add the results to your base. You simply provide a Bing Search API key and parameters like the search query term, country code, freshness (results from last 24h, last 7 days or last month) and the amount of maximum results, and hit "Search news" and it will populate automatically news articles in the table with: Title Published date Source Description Image (shown directly on table as attachment) Query (the search term) Status (default to New, in order to implement a "Curate workflow")

How I built it

Following Airtable guides and taking inspiration from their code example. I've implemented workflow with React

Challenges I ran into

Make a function with fetch that will correctly bring back JSON from Azure API

Understand how to create records

Figure out how to populate single select field

Figure out how to make the image directly look as an image, not just a url

Use the useSynced() function to GlobalConfig

Accomplishments that I'm proud of / What I learned

First time using React and Airtable Blocks

What's next for News Search Block

I've already implemented a good workflow with a Kanban to "curate" articles, next would be to make a block to generate a newsletter issue in html of the curated articles.

Share this project:

Updates