FB Ads Insights - Get spend by date
Status: Open · Asked by Baptiste Broch on · 0 views
Hi,
I would like to check my ads spend everyday, for the last day. For example, I want that Pabbly collects the spend for the last day in the A Column : today, I would like that this workflow shows how much I spend the 11th of March, 2025.
The idea is to automate a Google sheets Dashboard, without breaking formulas.
Pabbly is connected to FB Ads Insights, but I can't update a cell, only creating a new row below the data table
Hello @Map,
You can achieve this use case using the "Update Row Values" action. However, please note that when new ad data is added, the existing formula in the sheet may be overwritten.
Additionally, using the "Add New Row" action will replace the existing formulas in the sheet with the mapped values from Pabbly Connect.