How to Connect Meta Ads to Google Sheets (5-Minute Setup)

Getting your Meta Ads (Facebook & Instagram) data into Google Sheets shouldn't require a data engineer. Here's how to set it up in under 5 minutes.

Why Connect Meta Ads to Google Sheets?

If you're running Facebook or Instagram ads, you already know that Meta's Ads Manager is powerful but limited. You can see individual campaign metrics, but analyzing trends across campaigns, combining data with other marketing channels, or sharing insights with team members who don't have Meta access? That gets complicated.

Google Sheets solves this problem. By syncing your Meta Ads data to Sheets, you can:

• Combine multiple data sources - Pull Facebook data alongside Google Ads, TikTok, or email marketing metrics in one place
• Build custom reports - Create visualizations and dashboards that show what actually matters to your business
• Share with your team - Anyone with Sheets access can view reports without needing Meta Business Manager permissions
• Track history over time - Meta's dashboard shows current metrics; Sheets lets you see how performance has trended for months
• Feed other tools - Use Sheets as the source for Looker Studio dashboards, Slack notifications, or automated alerts
• Audit your spend - Having historical data in Sheets makes it easy to review past campaigns and catch anomalies

Whether you're a solo marketer or managing a team, this integration saves time and gives you better visibility into your ad performance.

Method 1: Using MetricNexus (Recommended)

MetricNexus is built specifically for marketers who need to connect their ad accounts to Google Sheets without dealing with APIs or complicated setup. The process is straightforward and takes about 5 minutes.

Step 1: Create Your MetricNexus Account

Head to MetricNexus.app and click "Start Free Trial" in the top right. You'll be prompted to enter your email and create a password. No credit card required—the free trial gives you full access to all core features for 14 days.

Once you're logged in, you'll see the MetricNexus dashboard with options to connect different ad platforms. Click "Connect Meta Ads" to begin.

[Screenshot: MetricNexus dashboard with "Connect Meta Ads" button highlighted]

Step 2: Connect Your Meta Ads Account

MetricNexus uses OAuth to securely connect to your Meta Business Account. When you click "Connect Meta Ads," you'll be redirected to Meta's authorization screen. This is the same flow you'd use to give any app access to your Meta account—MetricNexus only requests permission to read your ad data, not modify it.

You'll need:

• Access to your Meta Business Manager account
• Permission to view the ad accounts you want to sync

Select which ad accounts you want to connect (if you manage multiple accounts, you can choose one or all of them). MetricNexus will now have access to read data from those accounts.

[Screenshot: Meta OAuth permission screen showing "MetricNexus requests access to your ad accounts"]

Pro tip: If you don't see all your ad accounts in the list, check that you have the right role in Meta Business Manager. You need at least "Ad Account Admin" or "Ad Account Analyst" access.

Step 3: Choose Your Metrics

Once connected, MetricNexus shows you all available metrics from your Meta campaigns. You don't need to sync everything—pick the metrics that matter to your business.

Common metrics to start with:

• Spend - Total amount spent (essential for ROI calculations)
• Impressions - How many people saw your ad
• Clicks - How many people clicked
• Click-through rate (CTR) - Percentage of people who clicked (impressions/clicks)
• Conversions - Actions people took (purchases, signups, etc.)
• Cost per conversion - How much you spent per conversion
• ROAS - Return on ad spend (revenue divided by spend)
• CPM - Cost per 1,000 impressions
• CPC - Cost per click

You can also sync campaign names, status, and ID for organization. MetricNexus automatically pulls this data so you can filter and group by campaign in Sheets.

[Screenshot: MetricNexus metric selector with checkboxes for Spend, Impressions, Clicks, Conversions, ROAS, etc.]

Step 4: Connect Google Sheets

Now that you've selected your metrics, it's time to point MetricNexus to your Google Sheets. Click "Connect Google Sheets" and you'll be redirected to Google's authorization page.

MetricNexus will ask permission to:

• Create and edit spreadsheets
• Read your Google Drive files

Grant these permissions, then choose whether you want MetricNexus to create a new spreadsheet or use an existing one. If you're starting fresh, let MetricNexus create the sheet—it will pre-format columns and set everything up for you.

[Screenshot: Google OAuth screen and sheet selection dialog]

MetricNexus will create a spreadsheet named "Meta Ads Report" (or your custom name) and add columns for each metric you selected.

Step 5: Set Your Sync Schedule

The final step is choosing how often you want your data refreshed. MetricNexus offers three options:

• Hourly - Your data updates every hour. Good if you're actively monitoring campaigns and need near-real-time data
• Daily - Your data updates once per day at midnight UTC. The most popular option—enough frequency for daily optimization without overwhelming updates
• Weekly - Your data updates every Sunday. Best if you're doing weekly reporting and performance reviews

Choose your schedule, and you're done. MetricNexus will now automatically sync your Meta Ads data to Google Sheets on the schedule you selected.

[Screenshot: MetricNexus sync schedule dropdown showing Hourly, Daily, Weekly options]

That's it. Your Meta Ads data is now flowing into Google Sheets automatically.

Method 2: Using Supermetrics

If your team already uses Supermetrics for other integrations, you can also connect Meta Ads through their platform. Supermetrics is more established and offers advanced features like custom scheduling and data blending, but it comes at a higher cost ($99-299/month depending on features).

Setup time: 10-15 minutes

Pros:

• Established platform with robust features
• Works within Google Sheets as an add-on
• Advanced filtering and custom metrics
• Dedicated support

Cons:

• More expensive than alternatives
• Steeper learning curve for beginners
• More features than most small businesses need

If you're already paying for Supermetrics for Google Ads integration, adding Meta Ads is straightforward: install the add-on in Sheets, create a new query, select Meta as the data source, authenticate your account, and configure your metrics.

Method 3: Using Coupler.io

Coupler.io is a lightweight alternative with a free tier, making it ideal if you're budget-conscious and have basic reporting needs.

Setup time: 8-12 minutes

Pros:

• Free tier available
• Simple, intuitive interface
• Good for basic metrics and reporting
• Fast customer support

Cons:

• Limited metric flexibility compared to Supermetrics
• Free tier has slower refresh rates (daily maximum)
• Less customization for advanced use cases

Coupler.io works similarly to MetricNexus: connect your Meta account via OAuth, select metrics, pick your Google Sheet, and set a sync schedule. The main difference is a less polished UI and fewer available metrics, but for straightforward reporting, it gets the job done.

Method 4: Manual Export (Not Recommended)

You can always manually export data from Meta Ads Manager and paste it into Google Sheets. Here's why you shouldn't do this regularly:

• Tedious and time-consuming - Exporting data from Meta is a multi-click process every single time
• No automation - Your data will get outdated the moment you stop updating it manually
• Error-prone - It's easy to copy the wrong columns, miss campaigns, or overwrite previous data
• Doesn't scale - Managing multiple ad accounts or campaigns becomes increasingly painful

Manual export is fine for one-off analysis or spot-checking data, but for ongoing reporting and analysis, automation is essential. Your time is valuable—spending 30 minutes per week on manual exports adds up to over 26 hours per year that could be spent on strategy instead.

Free Google Sheets Template

We've created a pre-built Google Sheets template for Meta Ads reporting. It includes:

• Pre-formatted columns for all standard Meta metrics
• Dashboard sheet with charts showing spend trends, ROAS over time, and performance by campaign
• Raw data sheet where your synced data lands
• Pivot table sheet for quick analysis by campaign, date, or metric
• Conditional formatting to highlight high-spend or low-ROAS campaigns in red
• Instructions sheet with setup tips and metric definitions

[Screenshot: Template dashboard with charts and metrics visualized]

Download the free template here: MetricNexus Google Sheets Template

You can use this template with MetricNexus, Supermetrics, or any other integration tool. Just duplicate the template, connect your data source, and your automatic reports will start populating the raw data sheet.

What Data Can You Pull?

When you connect Meta Ads to Google Sheets, you have access to dozens of metrics organized into categories. Here's the complete list of what's available:

Campaign Metrics

• Campaign Name - Display name of the campaign
• Campaign ID - Unique Meta identifier (useful for filtering)
• Campaign Status - Active, paused, or ended
• Objective - Campaign objective (conversions, traffic, awareness, etc.)
• Campaign Budget - Total budget allocated to the campaign
• Start Date - When the campaign started
• End Date - When the campaign ended (if applicable)

Performance Metrics

• Impressions - Total number of times your ads were displayed
• Reach - Number of unique people who saw your ads
• Clicks - Total clicks on your ads
• Click-through Rate (CTR) - Percentage of impressions that resulted in clicks
• Spend - Total amount spent on the campaign
• Cost Per Click (CPC) - Average cost per click
• Cost Per 1,000 Impressions (CPM) - How much you paid per thousand impressions
• Frequency - Average number of times each person saw your ad

Conversion Metrics

• Conversions - Number of actions taken (purchases, signups, etc.)
• Conversion Rate - Percentage of clicks that resulted in conversions
• Cost Per Conversion - How much you spent per conversion
• Return on Ad Spend (ROAS) - Revenue generated divided by amount spent
• Conversion Value - Total value of all conversions

Engagement Metrics

• Likes - Number of likes on your ads
• Comments - Number of comments
• Shares - Number of times your ad was shared
• Post Engagement - Total engagement (likes, comments, shares)
• Video Views - Number of times your video was watched (if applicable)
• Video 3-Second Views - Standard definition for video views in Meta

Availability note: Not all metrics are available for all campaign types. For example, "Video Views" only appears for video campaigns. Dynamic product ads have different metrics than awareness campaigns. Most tools handle this automatically—they'll only show metrics that are relevant to your campaigns.

Common Issues and Fixes

"I can't see all my ad accounts"

The Problem: You connected MetricNexus, but not all your ad accounts appear in the selection list.

The Fix: Check your role in Meta Business Manager. You need at least "Ad Account Admin" or "Ad Account Analyst" access to grant read permissions. If you're an account manager but don't have these roles, ask your Business Manager administrator to upgrade your access.

Sometimes Meta's permissions are delayed. Try disconnecting and reconnecting your account—MetricNexus will refresh your available accounts.

"Data isn't updating"

The Problem: Your Google Sheet shows old data, and the most recent metrics aren't syncing.

The Fix: Check two things:

1. Verify your sync schedule is set to a time that has already passed today. If you set it to "daily at 11 AM" and it's currently 10 AM, wait until 11 AM.
2. Make sure your Meta account is still connected. MetricNexus will sometimes require you to re-authenticate if your Meta password changed or if you revoked third-party app access.

If data is still not updating after an hour, check your internet connection and try manually triggering a sync from the MetricNexus dashboard.

"Numbers don't match my Meta Ads Manager dashboard"

The Problem: The spend or conversion numbers in your Google Sheet don't exactly match what Meta shows.

The Fix: This is usually caused by attribution window differences. Meta Ads Manager shows data based on when the conversion was reported, but you can change this window from 1 day to 7, 28, or 30 days. Google Sheets syncs show data based on when the click happened, not when the conversion was reported.

For example: Someone clicks your ad on Monday, but doesn't convert until Thursday. Meta might show the conversion on Monday (when clicked) or Thursday (when converted), depending on your attribution settings. Make sure your attribution window matches between Meta and your reporting tool.

"Missing columns" or "Metric not available"

The Problem: You expected to see a certain metric, but it doesn't appear in your synced data.

The Fix: Some metrics are only available for specific campaign types or objectives. For example:

• Lead generation campaigns can measure "leads" but e-commerce campaigns can't
• Video campaigns show "video views," but image-only campaigns don't
• Certain metrics require specific pixel events to be tracked

Check Meta Ads Manager directly to see if the metric is available for that campaign type. If it shows in Meta but not in your sheet, the metric may not be available through the integration API (a limitation of Meta's API, not your tool).

Automating Your Reports

Now that your Meta Ads data is flowing into Google Sheets, here are ways to go further with automation and analysis:

Schedule Email Reports

Google Sheets lets you email your sheet to stakeholders on a schedule. Create a simple dashboard sheet, then go to File > Email Spreadsheet to set up daily or weekly emails. Include only the dashboard sheet so recipients see charts and summary metrics, not raw data.

Set Up Conditional Formatting Alerts

Use conditional formatting to highlight metrics that cross thresholds. For example:

• Highlight spend over $500 red
• Highlight ROAS below 2.0 red
• Highlight CPC increases in orange

This gives you visual alerts when something needs attention, without needing to check the sheet manually.

Connect to Looker Studio for Advanced Visualization

If you want sophisticated dashboards and visualizations beyond what Google Sheets offers, connect your sheet to Looker Studio (Google's free analytics visualization tool). Looker Studio connects directly to your Google Sheet and lets you create professional dashboards with filters, date ranges, and interactive charts.

Combine with Google Ads and Other Channels

Once you've got Meta Ads syncing, set up Google Ads, TikTok, or email marketing data in the same sheet. Build a unified dashboard showing spend and performance across all channels. This reveals which channels are most efficient and helps you optimize budget allocation.

FAQ

Q: How do I export Facebook Ads data to Google Sheets?

A: The easiest way is to use an integration tool like MetricNexus, Supermetrics, or Coupler.io. They automate the export and update your sheet on a schedule. Manual export is possible but tedious: go to Meta Ads Manager, navigate to the Campaigns tab, select your campaigns, click the Export button, and paste the CSV into Sheets. This works for one-off reports but isn't practical for ongoing reporting.

Q: Can I automate Facebook Ads reporting?

A: Yes. Any of the integration tools mentioned in this guide (MetricNexus, Supermetrics, Coupler.io) will automatically sync your Facebook Ads data to Google Sheets on a schedule you set. Once syncing is active, your reports update without any manual work.

Q: Is there a free way to connect Meta Ads to Sheets?

A: Yes, Coupler.io has a free tier, though it's limited to daily updates and basic metrics. MetricNexus also offers a free trial (14 days) that gives you full access. If you're willing to manually export, that's technically free but requires ongoing work. For ongoing automated reporting, you'll eventually need to pay for a tool, but starting with a free trial is smart to test the workflow first.

Q: How often does my data update?

A: It depends on your sync schedule. Most tools offer hourly, daily, or weekly updates. Daily is most common for marketing teams. Very recent events (last few hours) may not appear until the next scheduled sync, so if you need real-time data, choose hourly updates.

Q: Which metrics should I track?

A: Start with the essentials: spend, impressions, clicks, conversions, and ROAS. These five metrics tell you if your campaigns are working and costing what you expect. Once you're comfortable analyzing those, add CTR, CPC, and conversion rate. Metrics like frequency and video views are useful but secondary.

Q: Can I track multiple Meta accounts?

A: Yes. If you manage multiple Facebook Business Manager accounts, you can connect them all to MetricNexus and have them sync to the same Google Sheet. Your sheet will have all accounts' data in one place, which is ideal for comparing performance across accounts.

Next Steps

You now have everything you need to set up automated Meta Ads reporting in Google Sheets. Here's what to do next:

1. Download the free template - Grab the MetricNexus Google Sheets template to jumpstart your dashboard
2. Start your free trial - Sign up for MetricNexus, Supermetrics, or Coupler.io and connect your first ad account
3. Set up your first sync - Choose your metrics, pick your sync schedule, and let the tool run
4. Build a dashboard - Once data is flowing, create charts and summary metrics in your sheet
5. Share with your team - Email reports or give team members access to your Google Sheet for ongoing visibility

If you want to take your reporting further, check out our guide on Connecting Google Ads to Looker Studio for multi-channel visualization.

Happy reporting!