FB Ads Insights - Get spend by date

[Map]

Your Task History ID

https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTY5MDYzNTA0MzA1MjZiNTUzMTUxM2Ei_pc

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

 

[Preeti Paryani]

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.