We have many users using our Google Sheets Extension with great success. However some use cases might not be a good fit for Google Sheets due to compl

Connecting Google Sheets and SerpApi on Make.com

submited by

Style Pass

2024-10-01 20:00:06

We have many users using our Google Sheets Extension with great success. However some use cases might not be a good fit for Google Sheets due to complexity, scalability, or reliability concerns.

If you don't have the technical chops yourself or a developer to help you, you may be a bit stuck. Fortunately, you can integrate without writing any code using our SerpApi App on Make.com. This is a great no-code option for simply integrating SerpApi with other tools such as Google Sheets.

In this tutorial, I'll walk through a very basic example of how to query SerpApi with source data from Google Sheets. Then I'll show you how to both update existing rows in Google Sheets as well as adding new rows with the data returned from SerpApi.

First, we'll create a basic Google Sheet containing our keywords. We'll also add a few columns that will be destinations for data we get back from SerpApi's Google Search API.

Next, we'll head over to Make and create a new Scenario. The first Module we'll add is Get Range Values from the Google Sheets app.