How to Export Meta (Facebook) Ads to Google Sheets: Manual and Automated Methods

There are two main ways to import your Meta (Facebook) ads data into Google Sheets: a manual download from Meta Ads Manager, or an automated sync using a tool like DataFlowed. I'll walk you through both approaches so you can choose the one that fits your needs.

Manual Export from Meta Ads Manager

Meta Ads Manager has a built-in export feature that lets you download your campaign data as a CSV. It’s quick and free, but you’ll need to repeat these steps each time you want fresh data. To export manually:

1. Log in and open Ads Manager. Go to Meta Ads Manager and sign in with your Facebook (Meta) account. In the left menu, click Campaigns (or Ads or Ad Sets, depending on which level you want data for).
2. Select your campaigns and date range. Check the boxes next to any campaigns (or ad sets/ads) you want to report on. Set the date range at the top (for example, “Last 30 days” or a custom range).
3. Customize the columns. Click the Columns icon (a stacked-chart symbol) above the data table and choose Customize Columns. In the dialog, add or remove metrics like Impressions, Clicks, Cost, Conversions, etc., to match the analysis you need. When you’re done, click Apply to update the table.
4. Download the CSV. Look for the Export or Download button (often a download icon) in the top-right of the table. Click it and select CSV (or “Export to CSV”). This will download a CSV file of your selected data to your computer.
5. Import into Google Sheets. Open Google Sheets, go to File > Import, and upload the CSV file you downloaded. Choose to insert the data into a new sheet (so it doesn’t overwrite anything). Google Sheets will parse the CSV and display your ads data in a spreadsheet.

This manual export is straightforward and requires no special tools. However, it only captures the data up to the moment you downloaded it. If you need to update your report (for example, to get yesterday’s results), you must repeat all the above steps. For occasional, one-off reports, this is fine, but it can be tedious if you do it frequently.

• Pros: Quick setup, no cost or extra tools required. Good for a one-time snapshot of performance.
• Cons: Manual and time-consuming to repeat, data becomes outdated, and there’s a risk of human error each time.

After importing your CSV into Google Sheets, you’ll see your Facebook Ads metrics in a sheet. You can then create charts or pivot tables to analyze campaign performance.

Automate Meta Ads Exports with DataFlowed

Instead of doing all that work by hand, you can use DataFlowed to sync your Meta Ads data to Google Sheets automatically. DataFlowed is a no-code integration platform that connects your advertising accounts to Google Sheets. Once set up, it will regularly pull in new ad metrics on your chosen schedule, so your sheet is always up to date. This saves time and prevents errors – you never have to download CSVs again.

DataFlowed can automate your Facebook Ads exports to Google Sheets. First, connect your Meta (Facebook) Ads account and your Google account in DataFlowed’s Connections settings. Then go to the Export Builder and create a new export: select Meta as the data source and pick the Ad Account you want to sync. Choose the Google Sheet where the data should go, and give your export a name. Next, set the schedule – for example, daily or weekly refresh – so the export will run automatically. DataFlowed will then append fresh data into the sheet on that schedule. This way, your campaign performance data (clicks, spend, conversions, etc.) is always current without any manual effort.

Here’s a high-level setup process:

• Connect your Meta Ads account. In DataFlowed, go to Connections > Meta (or Facebook Ads) and click Connect Meta Account. Log in to your Facebook/Meta account and authorize DataFlowed (only read-only access is requested). Then select which Ad Account(s) you want to use for exports.
• Connect your Google Sheets. In DataFlowed, go to Connections > Google and authorize access to your Google account. Link the specific Google Sheet (or create a new one) where you want the data to land.
• Create a new export. Open the Export Builder in the DataFlowed dashboard and click New Export. For the Data Source, pick Meta (Facebook Ads), then choose the account you connected. For Google Sheets, select the spreadsheet you set up.
• Configure the export. Give it a descriptive name (e.g. “Weekly Facebook Campaigns”). Choose the date range of data to include (for example, “Last 30 days” or “Custom”). DataFlowed lets you export different data tabs (Campaigns, Ad Sets, Ads, Insights, Audiences) as separate sheets in the file. For each tab, you can choose which fields (columns) to include. For example, under Campaigns, you might include Campaign ID, Name, Spend, Impressions, Results, etc.
• Set the schedule. Decide how often to refresh. DataFlowed supports hourly, daily, weekly or custom schedules. For most ad reporting, a daily refresh is common.
• Create the export. When you finish the setup, click Create Export. DataFlowed will immediately run the export once and populate your sheet, then continue to do so on your schedule.

Once configured, DataFlowed will automatically fetch your Facebook Ads data and load it into Google Sheets. You can even have multiple tabs or sheets in one file (for campaigns, ad sets, individual ads, etc.). For example, you could have a “Campaign Performance” sheet with daily spend and results, and another tab for “Ad-Level Metrics.” You won’t need to log into Ads Manager again – DataFlowed takes care of updating the data for you.

Try DataFlowed for Meta Ads Reporting

Ready to streamline your Facebook Ads reporting? DataFlowed makes it easy to export your Meta Ads data into Google Sheets on autopilot. Sign up for a free account and connect your Facebook (Meta) Ads and Google Sheets. You can have your first automated export running in minutes – no coding required. Start a free trial of DataFlowed and see how simple it is to sync your ad data (daily, weekly, or however often you need) straight into a Google Sheet.