How to Link Data in Google Sheets

Tired of manually copy-pasting data from one tab to another? Linking data in Google Sheets automates your workflow, eliminates repetitive tasks, and ensures you’re always working with the most up-to-date information. In this tutorial, we’ll walk you through everything from basic cell linking to creating dynamic reports that pull data from entirely different spreadsheets.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Link Data in Google Sheets?

Before jumping into the "how," let's quickly cover the "why." Linking data isn't just a neat trick, it's a fundamental practice for clean and efficient data management. By linking data instead of copying it, you create a “single source of truth.” When the source data changes, every cell, chart, and report linked to it updates automatically.

This approach offers several key benefits:

• Saves Time: You only need to update data in one place. No more manually chasing down every instance of a number across multiple tabs or files.
• Reduces Errors: Manual data entry is prone to typos and mistakes. Linking your data eliminates the risk of copy-paste errors and mismatched information.
• Creates Dynamic Dashboards: You can build a master dashboard that summarizes key metrics from various other tabs or sheets, giving you a real-time overview without any manual refresh required.

Method 1: Basic Cell Referencing (Linking Within the Same Spreadsheet)

The simplest way to link data is by referencing cells from another tab within the same Google Sheets file. This is perfect for when you have raw data in one sheet and want to create a summary or dashboard in another.

Let's say you have a Google Sheets file named "Q3 Sales Report" with two tabs: "Raw Sales Data" and "Sales Summary."

In the "Raw Sales Data" tab, cell F50 contains the total sales revenue.

To pull this value into your "Sales Summary" tab, follow these steps:

1. Navigate to your "Sales Summary" tab.
2. Click on the cell where you want the total sales revenue to appear (e.g., cell B2).
3. Type the equal sign =.
4. Click on the "Raw Sales Data" tab.
5. Click on the source cell (F50).
6. Press Enter.

Google Sheets will automatically write the formula for you. Your formula bar in cell B2 of the "Sales Summary" tab will now show:

='Raw Sales Data'!F50

The single quote marks are necessary if your sheet name has spaces or special characters. Now, any time the value in 'Raw Sales Data'!F50 updates, the value in 'Sales Summary'!B2 will update instantly.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Pro Tip: Pulling an Entire Range

You can also pull an entire range of data. If you wanted to mirror the data from cells A1:D25 in your "Raw Sales Data" tab, you would use an array formula in cell A1 of your summary sheet:

={ 'Raw Sales Data'!A1:D25 }

This will duplicate the entire range, and it will update automatically as the source data changes.

Method 2: Using IMPORTRANGE (Linking Between Different Spreadsheets)

What if your data lives in a completely separate Google Sheets file? That's where the powerful IMPORTRANGE function comes in. This function lets you pull data from any cell or range in one spreadsheet directly into another.

The syntax for the function is:

IMPORTRANGE("spreadsheet_url", "range_string")

• spreadsheet_url: The full URL of the source Google Sheet you're pulling data from. You must wrap this in double quotes.
• range_string: The tab and range of cells you want to import, like "Sheet1!A1:B10". This also needs to be in double quotes.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step-by-Step Example

Imagine you have two separate files:

1. Source Sheet: A file named "Marketing Campaigns" with all your latest ad performance data. The URL is https://docs.google.com/spreadsheets/d/12345abcdef...
2. Destination Sheet: A file named "Master Business Dashboard" where you want to display this data.

Let’s say you want to pull the campaign performance table from cells A2:F50 in the "Facebook Ads" tab of your source sheet.

Here’s how to do it:

1. Open your "Master Business Dashboard" sheet.
2. Click into the cell where you want the data to start (e.g., A1).
3. Type in the following formula:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/12345abcdef...", "Facebook Ads!A2:F50")

1. Press Enter. The first time you do this, you'll see a #REF! error with a message that says "You need to connect these sheets."
2. Hover your cursor over the cell. A blue button will appear that reads "Allow access." Click it.

Your data will now magically appear and will remain synced with the source sheet. This one-time permission grant ensures you have authority to view the data you're requesting.

Method 3: Combining IMPORTRANGE with QUERY for Advanced Filtering

Pulling an entire data set is useful, but what if you only want to see specific information? By combining IMPORTRANGE with the QUERY function, you can import and filter your data using SQL-like commands - all within a single formula.

The QUERY function lets you sort, filter, and aggregate data dynamically.

The combined syntax looks like this:

=QUERY(IMPORTRANGE("spreadsheet_url", "range_string"), "SELECT Col1, Col3 WHERE Col2 = 'Value'")

Step-by-Step Example

Let's use our previous "Marketing Campaigns" example. The sheet has three columns: Campaign Name (Column A), Status (Column B), and Conversions (Column C). We want to pull only the active campaigns that have generated more than 50 conversions into our dashboard.

1. Open your "Master Business Dashboard".
2. In a free cell, write this formula:

=QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/12345abcdef...", "Facebook Ads!A2:C100"), "SELECT Col1, Col3 WHERE Col2 = 'Active' AND Col3 > 50")

Let's break that down:

• IMPORTRANGE(...): This first part is your standard IMPORTRANGE function, pulling raw data from columns A, B, and C in the "Facebook Ads" tab.
• QUERY(...): This wraps around the imported data so you can manipulate it.
• "SELECT Col1, Col3 WHERE Col2 = 'Active' AND Col3 > 50": This is the SQL-like statement. Here’s what it means:

The result is a clean, automated list of your top-performing active campaigns, updated in real time as your master data changes. No manual filtering required!

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Best Practices for Linking Data

As you get more comfortable linking data, keep these best practices in mind to avoid creating a hard-to-manage web of sheets:

• Name Your Tabs & Ranges Clearly: Using descriptive names like 'Q3 Raw Sales' instead of 'Sheet1' will make your formulas much easier to understand later.
• Simplify Your Permissions: If you're managing multiple files, it can be easier to organize them all within a shared folder in Google Drive to ensure permissions are consistent.
• Be Aware of Performance: Heavy use of IMPORTRANGE across many files can sometimes slow down your sheets. Use it where needed, but don't overdo it.
• Avoid Long Chains: Try to avoid situations where Sheet A pulls from Sheet B, which pulls from Sheet C, which pulls from Sheet D. A break anywhere in that chain can be difficult to diagnose and fix.

Final Thoughts

Mastering basic references, IMPORTRANGE, and QUERY allows you to create highly efficient, automated reporting systems directly within Google Sheets. These skills move you away from tedious manual data entry and toward building a single, reliable source of truth that powers your dashboards and decision-making.

While these formulas can dramatically cut down on spreadsheet work, they still require you to write, manage, and connect different data sets manually. At Graphed, we created our platform to handle all of this for you automatically. Instead of chaining formulas together, you just connect your sales and marketing platforms - like Google Analytics, Shopify, Facebook Ads, and Salesforce - and then ask for the report you need in plain English. We instantly build a live, interactive dashboard that pulls from all your data sources, skipping the spreadsheet wrangling entirely and getting you straight to the answers you need.