--- title: "Facebook Ads and Google Sheets: Automate Meta and TikTok Ads with Your Own Custom Data | Birch Course (formerly Revealbot)" description: "Use your own Google Sheets data in Meta ads rules: a single value or values per campaign or ad set ID, turned into custom metrics." url: https://bir.ch/birch-course/using-google-sheets-data-in-rules --- [Back to Birch course](https://bir.ch/birch-course) # Facebook Ads and Google Sheets: Automate Meta and TikTok Ads with Your Own Custom Data ## Transcript Welcome! In this video, we’ll show you how to connect Google Sheets with Birch to simplify ad management. By linking your own data—whether from internal systems or third-party tools—you can create custom metrics and rules for more precise automation. Let’s dive in! ## Setting Up Your Google Sheet There are two ways to structure your data: 1. Single Value – Use this if you need automation to trigger based on one value only. Place this value in a specific cell, like B1. 2. The 2nd option is “Values Associated with IDs” – Use this when each item (e.g., campaign, ad set) has its own value. One column will contain IDs (e.g., Ad Set IDs) Another column will have Values (e.g., purchases, leads) Make sure your sheet’s sharing settings are set to “Anyone with the link” so Birch can access it. There is a template linked in the video description. ## Creating a Rule Using a Custom Metric Let’s go through **two examples** to see how this works. ### Example 1: Using a Single Value We’ll create a first rule to pause active campaigns when total spend across Meta and TikTok reaches a limit. 1. Create a new rule. Scope: Campaigns, Filter: Active campaigns, Task: Pause. Now create a Google Sheet-based Custom Metric: - Click Create Custom Metric → Google Sheet → Single Value. Paste the sheet link and click Connect. - Type in B2, where total spend is stored. Here is what it looks like in the sheet. - Let’s give it a name"Spend  Meta + TT" and save. Set the condition: If this metric - “Spend Meta + TT” is greater than $2,400, pause all active campaigns. Schedule the rule to check every 15 minutes. It’s important to note the timeframe in the condition won’t apply—Birch always uses the latest value from your sheet. Great! This rule will monitor campaign spending using a Google Sheet custom metric based on your data. ### Example 2: Using Values Associated with IDs Now, let’s create another rule that will increase ad set budgets when they reach a certain number of leads. 1. In the scope we will have ad sets, task: Increase Budget by 20% once a day. 2. Set up a Google Sheet-based Custom Metric, here is what the sheet looks like - in column A I have ad set IDs and in column B Lead counts. Select Values associated with IDs, paste the sheet link, Connect. Column A (IDs) and Column B (Values), I will name it "Leads\_Daily", and save. Now set the condition: If Leads\_Daily is greater than 8 and Spend Today is less than $160, increase the budget. Another important note. If an ID is missing, Birch assumes its value is **zero**. To prevent unintended actions, avoid setting conditions that trigger on zero values by adding “Custom metric is more than 0” condition. And that’s it! Integrating Google Sheets with Birch is a great way to tailor your ad management and automation. Give it a try and see how it can improve your campaigns. ## Related articles in Help Center [How to use Google Sheets integration in automated rules](https://help.bir.ch/en/articles/6717341-how-to-use-google-sheets-integration-in-automated-rules) [How to export the attribution and tracking data into Google Sheets](https://help.bir.ch/en/articles/8558438-how-to-export-the-attribution-and-tracking-data-into-google-sheets) ## Related blog posts ### Birch + Google Sheets: Use external data in automated rules Ad Performance · July 25, 2025 · Birch Team [Birch + Google Sheets: Use external data in automated rules](https://bir.ch/blog/google-sheets-meta-ads-integration) Birch course 20 videos Getting Started - [Birch Platform Overview](https://bir.ch/birch-course/birch-platform-overview) - [Connect Your Meta, Google, TikTok and Snapchat Ad Accounts](https://bir.ch/birch-course/account-setup-configuration) - [Manage Multiple Ad Accounts and Clients with Workspaces](https://bir.ch/birch-course/workspaces-team-management) - [Birch Integrations: Slack, Google Analytics, AppsFlyer and More](https://bir.ch/birch-course/using-built-in-integrations) Analyze & Explore - [Ads Report Example: Meta, Google, TikTok and Snapchat in One Client Report](https://bir.ch/birch-course/building-cross-platform-reports) - [Ad Creative Analysis for Meta Ads: Creative Reports in Explorer](https://bir.ch/birch-course/creative-dashboards-in-explorer) - [Compare Meta Ads Audiences with Top Audiences](https://bir.ch/birch-course/audience-insights-in-top-audiences) Automate with Rules - [How to Automate Facebook, Google, TikTok and Snapchat Ads: The 6 Most-Used Rule Types](https://bir.ch/birch-course/most-popular-automation-rules) - [Custom Metrics for Meta, Google, TikTok and Snapchat Ads: Build Your Own Formulas](https://bir.ch/birch-course/creating-custom-metrics) - [Rule Logs and Activity: Why an Automated Rule Did or Didn’t Fire](https://bir.ch/birch-course/monitoring-rule-activity-logs) - [How to Scale Facebook Ads with 4 Automated Rules](https://bir.ch/birch-course/best-practices-for-meta) - [TikTok Ads Best Practices: 4 Automated Rules](https://bir.ch/birch-course/best-practices-for-tiktok) - [Best Practices for Snapchat](https://bir.ch/birch-course/best-practices-for-snapchat) - [Advanced Facebook Automated Rules: Timeframes, Comparisons and Rankings](https://bir.ch/birch-course/advanced-tips-for-automated-rules) - [Facebook Ads and Google Sheets: Automate Meta and TikTok Ads with Your Own Custom Data](https://bir.ch/birch-course/using-google-sheets-data-in-rules) Launch ads - [Ad Creative Testing in Bulk: Upload Creatives to Meta, TikTok and Snapchat from Google Drive with Stage](https://bir.ch/birch-course/stage-walkthrough-automatic-creatives-upload-and-ads-creation) - [Bulk Ads and Ad Sets Creation for Meta: Launch at Scale with Launcher](https://bir.ch/birch-course/creating-ads-at-scale-in-launcher) - [How to Set up Post Boosting Rules](https://bir.ch/birch-course/how-to-set-up-post-boosting-rules) - [Facebook Custom Audience and Lookalike Audience: Create and Manage in Birch](https://bir.ch/birch-course/creating-managing-audiences-in-birch) Server-side Tracking - [Set Up Meta Conversions API Gateway (Signals Gateway) for Server-Side Tracking](https://bir.ch/birch-course/birch-hub-signals-gateway) Birch course 20 videos [Book demo](https://bir.ch/demo) 14 · days free trial Cancel anytime No credit card required [Try Birch](https://app.bir.ch/signup)