How to search for added keywords in Google Sheets using Google Search and update the results in Google Sheets

Preparation

First, let's connect Yoom with each app.
Once logged into Yoom, select "+ New Connection" from the "My Apps" menu on the left.

Enter the necessary information to log into Google Sheets and Google Search.
An API token is required to register Google Search in My Apps.

Access the URL on the screen to obtain an API key with a few clicks.
If the account information is entered correctly for each app, it will appear in the My Apps list, so please check.

Once the My Apps registration is successfully completed, the preparation is complete.

App Trigger Settings

First, click on the first flow "When a row is added".
Check that the account information registered in My Apps during preparation is reflected.

No changes to the title and action are needed, so proceed to "Next" once the account information is confirmed.

On the next page, configure the detailed settings for the app trigger.
A trigger is a function that checks at set intervals whether a predetermined action has occurred in the flow. (The time that can be set varies depending on the plan.)

Once the trigger activation interval and required fields are completed, click "Test" to check for any errors.
If an error occurs, please refer to the link below.

About error causes and solutions

Once all errors are resolved, press "Save" to complete the app trigger settings.

Settings for Searching with Google Search

Next, select the second "Get Search Results".
As before, confirm the account information for Google Search registered in My Apps and click "Next".

On the next page, set up the search engine and search query.
A search query is the word or phrase you enter when searching.

In addition to names such as company names, entering details such as location in the field will allow you to obtain more accurate information.

After entering each, click "Test" to check for any errors.

If there are no issues, select "Save" to complete the settings up to this point.

Settings for Updating Google Sheets

Let's set up the final flow "Update Record".
On the first page, configure the details of the Google Sheets to be updated along with the account information.

Enter the correct spreadsheet ID and tab name.
Set the table range only if necessary.

Once the necessary information is entered, select "Next" to proceed.

On the next screen, enter the detailed settings for updating the record.
Change the conditions set in ① to the values specified in ②.
The conditions for the record you want to update can be set in detail, so please apply what suits you.

About precautions and solutions for obtaining Google Sheets records

Once everything is entered, click Test to check for errors.
If there are no issues, save and turn on the trigger.

With this, it will automatically research based on the search query from the conditions you set.

Other Automation Examples Using Google Sheets and Google Search

In addition to the integrations introduced today, various automations can be achieved by utilizing the APIs of Google Sheets and Google Search.

If you find something interesting, please give it a try!

‍‍Automation Examples Integrating Google Sheets and Google Search

It is also possible to integrate by searching keywords managed in a database on Google Search and recording the results in Google Sheets.

Automation Example Using Google Sheets

Notify Chat Tools When a Row is Added in Google Sheets

Automatically notify Slack, Discord, etc., when a row is added in Google Sheets.

Notify tasks due today in Google Sheets to chat tools in bulk daily

Automatically notify tasks due today in Google Sheets to Slack, Discord, etc., in bulk every day.

Add the content registered in the database to Google Sheets

Automatically add the content registered in Airtable, Salesforce, etc., to Google Sheets.

Automation Example Using Google Search

Search for company information on Google based on the information registered in the app and reflect the summarized content

Automatically search for company information on Google based on the information registered in Salesforce, Notion, etc., and reflect the summarized content.

Benefits of Integrating Google Sheets with Google Search

Integrating Google Sheets with Google Search allows you to allocate the time previously spent on research to other tasks, while efficiently gathering information.

 Benefit 1: Leads to Effective Time Management

By integrating Google Sheets with Google Search, you can significantly reduce the time spent on information gathering. Typically, manually searching for information based on data compiled in Google Sheets requires a lot of effort and time. Especially for marketers and researchers, it is necessary to process a large amount of data while finding accurate and up-to-date information.

However, by using this integration, you can automatically search for and easily import the necessary information using data from Google Sheets. This greatly shortens the information gathering process, allowing you to allocate more time to other important tasks.

For example, it is possible to automatically research and compile information about competitor companies. While the flowbot is running, you can dedicate time to planning marketing strategies or new projects, potentially increasing the time available for important tasks that contribute to the company's revenue.

Benefit: Effectively Gather Only the Necessary Information

Integrating Google Sheets with Google Search automatically gathers only the necessary information based on specified keywords. When gathering information manually, unrelated data or unnecessary information can sometimes get mixed in.

By using this integration, it searches according to the set conditions, allowing you to accurately capture only the desired information. For example, when you want to research market trends in a specific region, setting the conditions will automatically gather information only related to that region, making research very efficient.

‍Conclusion

The integration of Google Sheets and Google Search is a convenient method to streamline information management and significantly reduce the time spent on research. By using Yoom, you can automatically perform Google searches based on data from Google Sheets and easily collect the necessary information. This eliminates the hassle of manual information gathering and allows you to focus time on other important tasks. It is a powerful tool for marketers and researchers to achieve operational efficiency and accurate data acquisition. With Yoom, you can achieve app integration without programming knowledge. Why not streamline your operations?