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

The process only involves 6 steps, so you can set it 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 here.
If you are already using Yoom, please log in.

What is Yoom?

Yoom is a next-generation automation tool designed for those who want to streamline their daily administrative tasks and improve work efficiency! API integrations can be challenging for non-engineers, but Yoom eliminates the need for technical expertise or complex coding, allowing you to manage apps intuitively in one place with ease.

Sign Up for Yoom Here – Quick and Easy in Just 30 Seconds!

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 settings 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 Apps 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" on 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 the 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 interval" → Choose from 5 minutes, 10 minutes, 15 minutes, 30 minutes, 60 minutes
  * The trigger 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 the action to retrieve search results from Google Search

Next, to set up Google Search, click "Retrieve 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" → Retrieve search results
  

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

Scroll and use the Airtable output to set the "Search Query" as follows.
By clicking the arrow in the red frame, you can use the output.
After setting, click "Test" → "Test Successful" → "Save".
* By adding multiple keywords to the search query, you can access the information you want to search more easily.

Step 4: Set the operation to summarize

Next, to set up summarization, click "Summarize".
* AI operations are available only in some paid plans.
For other plans, the operations 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 "Retrieve 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 the 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 the "Record ID" using the output from "When a record is registered".

Scroll and set the "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 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 that automatically creates a folder in Google Drive when a client is registered in Airtable.
It eliminates the need to manually create a folder every 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.
Manual work is reduced, easing the burden on the person in charge.

3. This is a flow where keywords added in Google Sheets are searched on Google, and the results are automatically updated in Google Sheets.
It is recommended for conducting competitive research, such as searching for product names or company names, as you can search with any keywords.
Since the results can be automatically updated in Google Sheets, manual data entry is no longer necessary.

Summary

The integration of Airtable and Google Search facilitates the collection and management of company information.
This automation can reduce the effort required for frequently updated data tasks, contributing to time savings.
As a result, personnel can focus more on core tasks, potentially leading to increased productivity for the entire team.
Let's incorporate this automation to improve daily work efficiency.

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