■Overview
This is a flow bot that automatically retrieves report information from the previous day's Google Ads at a specified time every day and records it in Microsoft Excel.
■Recommended for
1. Companies using Google Ads
・Those using it to enhance brand awareness
・Those using it for ad performance measurement and improvement
2. Those utilizing Microsoft Excel in their work
・Those accumulating data for visualization and team sharing
・Those creating sheets for each theme to accumulate information
■Benefits of using this template
Google Ads is not only a tool for displaying ads but also for obtaining detailed results for performance measurement and improvement. By accumulating the obtained results in Microsoft Excel, it leads to long-term performance measurement. However, manually obtaining and entering measurement results each time is very labor-intensive and increases the risk of human error.
By utilizing this flow, you can not only automatically obtain reports from Google Ads but also automatically add results to Microsoft Excel. Automating the process from report retrieval to result addition frees you from daily routine tasks, allowing you to focus on core tasks. By enabling the entire team to concentrate on tasks of varying importance, it leads to improved work efficiency.
■Notes
・Please connect both Google Ads and Microsoft Excel with Yoom.
・Microsoft365 (formerly Office365) has both a home plan and a general business plan (Microsoft365 Business). If you are not subscribed to the general business plan, authentication may fail.


Retrieve Account Report
Retrieve Specific Campaign Report
Retrieve Ad Group Report
Retrieve Keyword Search Volume
Retrieve Keyword Suggestions
Get Reports for Multiple Campaigns
Get Report for Specific Campaign (by Ad Network Type)
Get Reports for Multiple Campaigns (by Ad Network Type)
Get Worksheet Information
Get Specific Cell Value
Get Range in Columns
Get Range in Rows
Add Sheet
Change Sheet Name
Retrieve Table List
Add Table
Enter Formula in Cell
Enter Value in Cell
Retrieve Account Report
Retrieve Specific Campaign Report
Retrieve Ad Group Report
Retrieve Keyword Search Volume
Retrieve Keyword Suggestions
Get Reports for Multiple Campaigns
Get Report for Specific Campaign (by Ad Network Type)
Get Reports for Multiple Campaigns (by Ad Network Type)
Get Worksheet Information
Get Specific Cell Value
Get Range in Columns
Get Range in Rows
Add Sheet
Change Sheet Name
Retrieve Table List
Add Table
Enter Formula in Cell
Enter Value in Cell
Get Item ID
Delete Sheet
Sort a specified range in ascending or descending order
Unprotect Worksheet
Get Drive Item ID from Sharing URL
Create Excel Session