Integrate Airtable with Google Search to automatically update summarized results by searching for company information on Google using keywords added to Airtable.

The process consists of only 6 steps, so it can be set up in 10-15 minutes.

1. Register Airtable and Google Search as My Apps
2. Set a trigger to activate when a record is registered in Airtable
3. Set an action to retrieve search results from Google Search
4. Set an operation to summarize
5. Set an action to update records in Airtable
6. Verify the automation of Airtable and Google Search

If you are not using Yoom, please register for free from here.
If you are already using Yoom, please log in.

[What is Yoom]

Step 1: Register Airtable and Google Search as My Apps

Please register Airtable and Google Search as My Apps in Yoom.
Registering as My Apps first makes automation setup easy.

First, let's register Airtable as My App.
Please refer to the help page here to register.

Next, let's register Google Search as My App.
Click "My Apps" → "New Connection" on the left side of the Yoom screen.
Search for Google Search from "Search by App Name" or find it from the app list.

The following screen will be displayed, so please log in to Google Search.

Once both My App registrations are complete, Airtable and Google Search will be displayed.

Step 2: Set a trigger to activate when a record is registered in Airtable

To set up automation, click "Try it" in the banner below.

Read the following screen display and click "OK".

The following screen will be displayed, so check the "Title" and "Description".
If you want to make changes, you can do so from the screen below.
Since it is done from Airtable settings, click "When a record is registered".

When the following screen is displayed, please check the settings.

• "Title" → Can be freely changed
• "Account information to link with Airtable (OAuth)" → Check for discrepancies
• "Trigger Action" → When a record is registered
  

The following screen will be displayed, so check the setup method.
For how to obtain field information of records, please check here.

The following screen will be displayed, so set the required items.

• "Trigger activation interval" → Select from 5 minutes, 10 minutes, 15 minutes, 30 minutes, 60 minutes
  ※ The activation interval varies depending on the plan, so please be careful.
• "Base ID", "Table ID", "Field name of Created Time" → Check the description and set

After setting, click "Test" → "Test successful" → "Save".

Step 3: Set up an action to get search results on Google Search

Next, to set up Google Search, click "Get search results".
When the following screen is displayed, check the settings.

• "Title" → Can be freely changed
• "Account information to link with Google Search" → Check for discrepancies
• "Action" → Get search results
  

The following screen will be displayed, so check the description and set the "Search Engine ID".

Scroll and use Airtable's output to set the "Search Query" as follows.
Click the arrow in the red frame to use the output.
After setting, click "Test" → "Test successful" → "Save".
※ By adding multiple keywords to the search query, it becomes easier to access the information you want to search for.

Step 4: Set up an operation to summarize

Next, to set up summarization, click "Summarize".
※ AI operations are features available only in some paid plans.
In other plans, the operation of the flow bot being set will result in an error, so please be careful.
Paid plans offer a 2-week free trial.
During the free trial, you can use restricted apps and AI features (operations), so please try them out.
When the following screen is displayed, check the settings.

• "Title" → Can be freely changed
• "Action" → GPT4o‐mini | Summarize text within 3,500 characters (3 tasks)

The following screen will be displayed, so check the precautions.

Scroll and set the "Text to be summarized".
Select "List of snippets" from the output of "Get search results" in Google Search and set it.

Scroll and check the description, then set the "Number of characters".
After setting, click "Test" → "Test successful" → "Save".

Step 5: Set up an action to update records in Airtable

To set up updating search results in Airtable, click "Update record".
When the following screen is displayed, check the settings.

• "Title" → Can be freely changed
• "Account information to link with Airtable" → Check for discrepancies
• "Trigger Action" → When a record is updated
  

The following screen will be displayed, so check the precautions.

Scroll and check the description, then set the following required items.

Scroll and set "Record ID" using the output of "When a record is registered".

Scroll and set "Field Information".

• "Field Name" → Enter the name of the field where you want to add the summary result
• "Value" → {{Summary Result}}
  ※ Select "Summary Result" from the output of "Summarize".

After setting, click "Test" → "Test successful" → "Save".

Step 6: Verify the automation of Airtable and Google Search

Finally, click "Turn on Trigger" to complete the automation setup.
Check if the flow bot is starting up correctly.

Flow bot template used this time
Search for company information on Google using keywords added to Airtable, summarize the search results, and update them in Airtable

Other Examples of Automation Using Airtable and Google Search

1. This is a flow where a folder is automatically created in Google Drive when a client is registered in Airtable.
It eliminates the need to manually create a folder each time a client is registered.
Folders are organized by client, preventing file loss.

2. This flow automatically searches Airtable records and sends emails via Gmail according to the specified schedule.
It allows for task management at set intervals, preventing tasks from being overlooked.
This reduces manual work and alleviates the burden on those responsible.

3. This is a flow that automatically updates Google Sheets with the results of Google searches for keywords added to the sheet.
You can search with any keywords, making it recommended for competitive research such as product names or company names.
Since the results can be automatically updated in Google Sheets, manual data entry becomes unnecessary.

Summary

Integrating Airtable with Google Search facilitates the collection and management of company information.
This automation reduces the effort required for frequently updated data tasks and contributes to time savings.
As a result, team members can focus more on core tasks, potentially enhancing overall team productivity.
Incorporate this automation to improve daily work efficiency.

If you are interested in Yoom, please register for free here.