■Overview
This flow retrieves the latest information from Meta Ads (Facebook) account reports and Google Ads campaign reports daily and adds it to a Google Spreadsheet.
With Yoom, you can easily achieve this flow without the need for programming, as it allows for integration between apps.
■Recommended for
■Benefits of using this template
To properly manage ad operations, performance review and analysis are crucial, but spending too much time on information gathering and report creation can hinder your primary tasks.
By implementing this flow, you can obtain report information from Meta Ads (Facebook) and Google Ads at a specified time daily and synchronize the necessary items with Google Spreadsheets.
This prevents omissions and transcription errors, reduces report creation time, and allows you to smoothly proceed with more strategic tasks such as data analysis and ad operation planning based on highly accurate information.



When a row is added
When a row is updated
When Lead Information is Created
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)
Input Value into Cell
Retrieve Value
Delete Values
Create a New Spreadsheet
Copy Sheet (Tab)
Add a New Sheet (Tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
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)
When a row is added
When a row is updated
Input Value into Cell
Retrieve Value
Delete Values
Create a New Spreadsheet
Copy Sheet (Tab)
Add a New Sheet (Tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Information
Get Sheet Names
Repeat Formula
Input Values into Range
Embed Image in Cell
Sort by Specific Column
Hide Sheet
Add Note to Specified Cell
Add Column
Delete Columns
When Lead Information is Created
Create Ad Account Report
Get Ad Account Report
Create Campaign Report
Get Campaign Report
Create Ad Set Report
Get Ad Set Report
Create Ad Report
Get Ad Report