How to retrieve the previous day's report from Google Ads every day and record it in Google Sheets

1. Click "Try it"
2. Register for Yoom
* If you have already completed registration, the login screen will be displayed, so please log in.

Step 2: Set Triggers and Actions

As you proceed, the template will be copied to your workspace.
If necessary, you can change the name of the template.
Click My Projects on the left, and the template you just copied will appear, so click the ellipsis (...) on the right and select Edit.

‍

‍

Let's set the schedule trigger.
Select "When becoming the specified schedule".

‍

‍

If there are no issues with the following screen, save it.
Since you want to set the time to 10 AM, enter 10.

‍

‍

Next, click "Get Account Report".

‍

‍

Check the account information to be linked.
Proceed with the action as is.
Let's set up the API connection.
Ad Account ID: You can check it from the Google Ads management screen.
Start and End of Period: Left-click in the input field to bring up "Output - Date", then find the yesterday field and select {{yesterday_%Y-%m-%d}}.

‍

‍

There is an output field at the bottom of the screen.
If you make the title of the output a header in Google Sheets, it will be easier to understand what the item is when transcribing.

‍

‍

I set it up like this in the spreadsheet.
(I added the date myself so that I could tell when the report was from.)

‍

‍

Next, click "Calculation (Arithmetic Operations)".
You can see the end of the setup!

‍

‍

For more details on "Performing Calculations", please check here.

If there are no issues with the operation conditions, save and click.

‍

‍

Next, click "Operate on Database".

‍

‍

Integrate with the database.
Spreadsheet ID & Tab Name: Select from candidates
Table Range: Set as desired

‍

‍

Set the values for the records to be added.
The following screen will appear, so select the items that match from the output.
Test → Save if the test is successful.

‍

‍

Finally, turn on the app trigger to complete.

‍

Thank you for your hard work!

Other Automation Examples Using Google Ads and Google Sheets

In addition to the flow introduced this time, you can achieve various business automations by using the APIs of Google Ads and Google Sheets.
All of them can be used with simple settings, so if you find something interesting, please give it a try!

Other Automation Examples with Google Ads and Google Sheets‍

It is also possible to obtain the latest reports from Google Ads starting with the action of adding a row in Google Sheets.
Additionally, you can integrate with Meta Ads (Facebook) to obtain the latest information from Meta Ads (Facebook) account reports and Google Ads campaign reports and add information.

Examples of Automation Using Google Ads

Obtain Campaign Reports from Google Ads When a Specific Action is Taken

By using the action as a starting point, the latest campaign reports can be automatically retrieved, potentially eliminating the need for manual data entry.

Retrieve and Notify the Latest Google Ads Reports

You can automate the retrieval and notification of the latest reports from Google Ads at a set time every day, which can improve work efficiency.

Automation Example Using Google Sheets

Notify by Email When a Row is Added or Updated in Google Sheets

By integrating Yoom's email functionality, it may be possible to prevent human errors such as transcription mistakes and missed notifications.

Send an email when a status is updated in Google Spreadsheet

This eliminates the need to manually enter recipients and email text, potentially reducing the risk of transcription errors or missed deliveries.

Retrieve information and add it to Google Sheets at the specified schedule

By automatically retrieving and adding information at the specified schedule, it is expected to prevent manual transcription errors and omissions.

Add a Record When a Row is Added in Google Sheets

By eliminating the need for manual data entry, input errors should decrease, and data accuracy should be maintained.

Benefits of Integrating Google Ads with Google Sheets

Benefit 1: Time Savings

For marketers, creating daily reports is one of the tasks they want to streamline. By integrating Google Ads with Google Sheets, the process of manually obtaining reports and entering data daily is automated, allowing you to focus on other tasks during that time! For example, you might be able to allocate more time to data analysis of ad campaigns or devising new strategies.

Benefit 2: Improved Data Accuracy

When entering data manually, human errors such as omissions or input mistakes can occur, which may lead to incorrect judgments in ad performance measurement, strategy planning, and improvement measures. By implementing the integration of Google Ads and Google Sheets, you can enhance data accuracy and potentially create more reliable reports. This will not only improve the quality of ad management but also lead to faster decision-making. This integration could be particularly useful when handling large amounts of data or managing multiple campaigns.

Conclusion

By using Yoom to integrate Google Ads with Google Sheets, you may have experienced the convenience of having reports automatically transferred to spreadsheets daily without the need for complex coding.

While the coding setup is only in English, Yoom can be operated in Japanese. Automating manual data entry can save time and improve data accuracy. Creating graphs and charts based on automatically transferred data could make the effectiveness of ad campaigns more easily understandable.

Please try this method and enhance your work efficiency!