Latenode
Facebook
Google sheets

Automatically sync Facebook Ads data to a Google Sheets report

This automation allows social media marketers to automatically fetch and sync daily campaign data from Facebook Ads to a Google Sheets report, leveraging the Facebook Graph API to retrieve the latest metrics like campaign status, spend, and other key performance indicators.

The workflow runs on a scheduled trigger, connecting to the user's Facebook Ads account, fetching the relevant data, and updating the corresponding Google Sheets spreadsheet. This helps streamline the reporting process and provides real-time visibility into Facebook ad campaign performance without the need for manual data exports.

Updated Apr 6, 2026Est. run: 26sEst. cost: $0.0703
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
Social media

Workflow preview

What this template does

  • Fetches daily Facebook Ads campaign data using the Facebook Graph API.
  • Normalizes the retrieved metrics and stores them in a Google Sheets report.
  • Automates the reporting process by scheduling the data sync on a regular basis.
  • Provides real-time visibility into Facebook ad campaign performance metrics.
  • Generates a Google Sheets report with the latest Facebook Ads campaign data.

How it works

1
Trigger

Connect Facebook Graph API

The automation begins by connecting to the user's Facebook Ads account through the Facebook Graph API. This allows the workflow to access the necessary data and metrics from the user's Facebook ads campaigns.

2
Action

Get Campaign ID from Google Sheets

The workflow then fetches the relevant campaign IDs from a Google Sheets spreadsheet. This spreadsheet acts as a centralized location to store the campaign information that needs to be tracked and reported on.

3
Action

Fetch Campaign Statistics

Using the campaign IDs obtained from the Google Sheets spreadsheet, the automation then retrieves the latest campaign data and metrics from the Facebook Graph API. This includes information such as campaign status, spend, and other key performance indicators.

4
filter

Check if Campaign is Active

The workflow then filters the campaign data to only include active campaigns. This ensures that the reporting focuses on the campaigns that are currently running and providing relevant, up-to-date information.

5
Action

Update Google Sheets

The filtered and processed campaign data is then added to the corresponding Google Sheets spreadsheet. This updates the report with the latest Facebook ads performance data, providing real-time visibility into the campaign's performance.

6
Action

Aggregate Campaign Statistics

Finally, the workflow summarizes and formats the campaign data within the Google Sheets report, making it easier for the social media marketers to analyze and gain insights from the Facebook ads performance.

Setup guide

1

Add Facebook Graph API Credential

Add your Facebook Graph API credential in the Latenode Credentials panel. You'll need to provide your Facebook App ID and App Secret obtained from the Facebook Developer Portal.

2

Configure Facebook Graph API Node

In the Latenode visual builder, add a Facebook Graph API node and select the credential you added in the previous step. Then, configure the node to fetch the required campaign data from the Facebook Ads API.

3

Add Google Sheets Credential

Add your Google Sheets credential in the Latenode Credentials panel. You can either use a service account key or an OAuth 2.0 client ID and client secret.

4

Configure Google Sheets Node

In the Latenode visual builder, add a Google Sheets node and select the credential you added in the previous step. Then, configure the node to specify the Google Sheets spreadsheet and worksheet where you want to store the Facebook Ads campaign data.

5

Map Facebook Ads Data to Google Sheets

In the Google Sheets node settings, map the relevant Facebook Ads campaign data fields (e.g., campaign status, spend, etc.) to the corresponding Google Sheets columns.

Requirements

Connect your Facebook Ads account to authorize access to your ad data
Obtain a Google Sheets API key and connect your Google Sheets account to allow writing data
Set up a scheduled trigger to automatically run the workflow on a regular cadence (e.g. daily)
Ensure the workflow has the necessary permissions to read your Facebook Ads data and write to the target Google Sheets spreadsheet

FAQ

Common questions about this template

To set up the Facebook Ads to Google Sheets automation, you'll need to connect your Facebook Ads account and your Google Sheets account. The workflow will automatically fetch the latest campaign data from Facebook and update the corresponding Google Sheets report on a scheduled basis.
Contact support →

More templates

You might also like

Browse all templates →
Social media

Automatically like fresh Instagram posts with AI-powered targeting

This Latenode automation template helps social media managers and brands maintain an active and engaged presence on Instagram by automatically liking fresh posts on selected hashtags. The workflow uses a rotating set of Instagram session cookies, AI-powered hashtag generation, and Phantombuster web scraping to streamline the process, reducing the need for manual intervention. The scheduled trigger runs every 2 hours, selecting a random cookie and generating relevant hashtags to target new posts, then automatically liking them. The solution integrates with Instagram, Phantombuster, Microsoft SharePoint, and OpenAI to provide a comprehensive automation experience.

26s$0.0703
Social media

Automate your sales outreach with Apify, GPT-4o, and WhatsApp

This automated workflow streamlines the sales cold calling process by integrating web scraping, natural language processing, and WhatsApp messaging. It leverages Apify to extract lead data from social media and web sources, generates personalized sales scripts using GPT-4o, and sends automated outreach messages via WhatsApp to connect with potential customers. The workflow is designed for sales teams looking to optimize their cold calling pipeline and increase productivity by automating repetitive tasks.

26s$0.0703
Social media

Automatically sync LinkedIn lead gen form data to Google Sheets

This automation solution is designed to help marketers and sales teams efficiently capture and track new lead generation form responses from LinkedIn Ads. The automation will automatically transfer the lead details, such as name, email, and other relevant information, into a centralized Google Sheets spreadsheet. This provides a unified view of all incoming leads, allowing for better organization, analysis, and follow-up. By streamlining the lead capture process, users can focus on nurturing and converting these potential customers, rather than manually managing multiple data sources.

25s$0