■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)
Retrieve Search Terms Report
Set a value in a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
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)
Retrieve Search Terms Report
When a row is added
When a row is updated
Set a value in a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Info
Get sheet names
Apply a formula to a range
Write values to a range
Insert image into a cell
Sort by a specific column
Hide a sheet
Add a note to the specified cells
Insert columns
Delete columns
Write values to multiple 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