Automatically sync Facebook Ads data to a Google Sheets report
This template runs on a schedule, calls the Facebook Marketing API Insights endpoint from JavaScript, and writes campaign metrics to Google Sheets. Use it for a daily spend report without exporting ads data by hand. Connect Google Sheets. Put the Marketing API token in that JavaScript node. Map ad account id, date range, and the sheet columns you want.