Google Sheets

Google Sheets is Google's cloud-based spreadsheet application. By connecting Google Sheets to Coupler.io as a source, you can automatically export data from your spreadsheets to any supported destination — including other spreadsheets, BI tools, databases, and AI tools — on a schedule, without manual exports or copy-pasting.

Coupler.io's Google Sheets integration connects via Google OAuth and lets you pull data from one or more sheets in a spreadsheet, merge data across multiple sheets, and use regex patterns to automatically include new sheets as they appear.

Why connect Google Sheets to Coupler.io?

• Consolidate spreadsheet data — Merge data from multiple sheets or multiple spreadsheets into a single destination for unified reporting and analysis.

• Automate recurring exports — Schedule data transfers so your reports, dashboards, and data pipelines stay current without manual intervention.

• Use regex-based sheet matching — Automatically include new sheets that match a naming pattern (e.g., Sales 2026.+) without updating your data flow every time a new sheet is added.

• Flexible destinations — Export to AI tools, Google Sheets, Excel, BigQuery, Looker Studio, or other supported destinations.

Prerequisites

Before connecting, make sure you have:

• A Google account with access to the Google Sheets spreadsheet(s) you want to export

• A Coupler.io account

The Google account you connect must have at least Viewer access to the spreadsheet. If you need to export from a shared spreadsheet, make sure the spreadsheet has been shared with your Google account before connecting.

Quick start

Start by selecting a single sheet and using A:Z as the range — this exports all columns and all existing rows, including any new rows added in the future. If you need to merge data from multiple sheets with the same structure, select all of them: Coupler.io will stitch the data by column headers and add a Sheet Name column so you can identify the source of each row.

How to connect

1

In Coupler.io, create a new data flow and select Google Sheets as the source.

2

Click Connect and sign in with your Google account. Grant Coupler.io permission to access your Google Drive and Sheets data.

3

Select the spreadsheet from your Google Drive and choose one or more sheets to export from. Alternatively, enter a regex pattern to match sheets by name.

4

Set the Range for each selected sheet (e.g., A:Z to export all columns and rows, or A1:Z100 for a fixed range).

5

Choose your destination and run the import.

Google Sheets data overview

Coupler.io's Google Sheets integration pulls data directly from your spreadsheets via the Google Sheets API. You select a spreadsheet, one or more sheets, and a data range — Coupler.io reads the cells and exports them row by row to your destination.

What data is exported

When you export a Google Sheets source, each row in the spreadsheet becomes a row in your destination. The first row of the selected range is treated as the header row (column names). All subsequent rows are data rows.

Column	Description
(your columns)	All columns from the first row of the selected range become output column names
Sheet Name	Added automatically when exporting multiple sheets — identifies which sheet each row came from

Column names are taken from the first row of each sheet's selected range. If the first row is empty or contains merged cells, column names may be missing or duplicated. Clean up header rows in the source spreadsheet before connecting.

Configuration options

Spreadsheet

Select the Google Sheets file to export from. The file picker shows spreadsheets accessible to the connected Google account from Google Drive.

Sheets

Choose one or more sheets (tabs) to export from the selected spreadsheet:

• Single sheet — exports data from one tab only

• Multiple sheets — exports data from all selected tabs; rows are stitched together by matching column headers, and a Sheet Name column is added to identify the source tab

• Regex pattern — instead of selecting sheets manually, enter a regular expression to match sheet names dynamically

When merging multiple sheets, columns are matched by name. Sheets with different column structures will produce rows with empty cells in columns that don't exist in that sheet.

Regex sheet name patterns

Instead of selecting sheets by name, you can enter a regex pattern to match sheets automatically. This is useful when new sheets are added regularly (e.g., monthly sales tabs). Common patterns:

Pattern	Matches
.*	All sheets in the spreadsheet
Sales 202.+	Sales 2020, Sales 2021, Sales 2026, etc.
.*Q[1-4] 2025.*	Any sheet containing Q1–Q4 2025
Report.+	Any sheet whose name starts with "Report"
.*summary	Any sheet whose name ends with "summary"

The order of sheets in the merged output follows the order of the tabs in the spreadsheet, not the order in which you selected them. If you need data in a specific order, arrange the sheet tabs accordingly in Google Sheets.

Range

Set the data range to export from each sheet. Examples:

Range	Behavior
A:Z	All columns A through Z, all existing rows (including new rows added later)
A1:Z9	Fixed range: columns A–Z, rows 1–9 only
A1:Z	Columns A–Z, from row 1 to the last row with data
1:1	First row only (useful for exporting headers to check column names)
B2:E	Columns B–E, starting from row 2 (skips the first row)

Use open-ended ranges like A:Z or A1:Z to automatically capture new rows added to the sheet over time. Static ranges like A1:Z9 only export the specified rows and will miss any data added below row 9.

Use cases by role

Operations

Use Google Sheets as a source to move operational data (project trackers, inventory logs, task lists) maintained in spreadsheets into a database or BI tool. Schedule daily exports so downstream tools always reflect the latest spreadsheet state without manual uploads.

Finance

Export budget models, expense trackers, or financial forecasts from Google Sheets into BigQuery or a data warehouse. Combine with ERP or accounting source data in Coupler.io to reconcile spreadsheet-based planning against actual financial data.

Marketing

Merge campaign tracking sheets (one per month or per channel) using regex patterns. Coupler.io automatically picks up new monthly sheets as they're added, keeping your consolidated marketing report up to date without touching the data flow.

Data Engineering

Use Google Sheets as a lightweight lookup table or configuration source alongside other data flows. Pull reference data (e.g., product category mappings, cost tables, team assignments) from a spreadsheet and join it in your destination with other source data.

Row limits apply. Google Sheets is a metered source — the number of rows exported per run depends on your Coupler.io plan (Free: 100, Personal: 1,000, Professional: 10,000, Team: 100,000, Business: unlimited). If your export seems truncated, check your plan's limit on the pricing page.

Platform-specific notes

• Header row required — The first row of the range must contain column names. Coupler.io uses this row as the schema. If there is no header row, data will be misinterpreted.

• Empty rows are skipped — Rows where all cells are empty are skipped during export.

• Data types are inferred — Numbers, dates, and booleans are exported with their cell values. Dates in non-standard custom formats (e.g., 2025-01-12 (Mon)) may be imported as text — see Common Issues for fixes.

• Large spreadsheets may time out — Sheets with hundreds of thousands of rows or many heavy formulas can exceed the 9-minute import timeout. See Common Issues for guidance.

• Formula cells export their computed values — Coupler.io reads the cell value, not the formula. =SUM(A1:A10) exports as the numeric result.

• Merged cells export the value of the top-left cell — Other cells in the merged region export as empty.

• Google Drive permissions required — The connected Google account must have at least Viewer access to the spreadsheet. Spreadsheets restricted to specific users or domains will only be accessible if the connected account is included.

Google Sheets common issues

Connection issues

Cannot connect Google account — OAuth popup fails or closes

Problem: Clicking "Connect" opens the Google sign-in screen but it fails to complete, or closes without saving the connection.

Fix:

1. Disable browser popup blockers and ad blockers for coupler.io and accounts.google.com.

2. Clear browser cookies and try again in an incognito window.

3. Make sure you're signing in with the Google account that has access to the spreadsheet you want to export.

4. If your Google Workspace account has restricted third-party app access, ask your Google admin to allow Coupler.io.

Google 400 error — "The server cannot process the request. Sign in is required."

Problem: When selecting a spreadsheet in the file picker, you see a Google 400 error or a "Sign in is required" message instead of your files.

Fix:

1. This typically happens when browser cookies for Google are blocked or expired. Allow third-party cookies for coupler.io and accounts.google.com in your browser settings.

2. Try using a different browser or incognito mode.

3. If your Google account uses multiple sessions (e.g., personal + work), make sure you're signed in to the correct account in the same browser tab.

4. Disconnect and reconnect the Google Sheets connection at coupler.io/app/connections.

Spreadsheet not appearing in the file picker

Problem: The spreadsheet you want to export is not visible in the file picker when setting up your data flow.

Fix:

1. Confirm the spreadsheet is shared with the connected Google account — it must have at least Viewer access.

2. If the spreadsheet is on a Google Workspace shared drive, ensure the connected account has access to that drive.

3. Try searching for the spreadsheet by name in the file picker search box.

4. If the spreadsheet was recently shared, allow a few minutes for Google Drive to propagate permissions.

"The API developer key is invalid" error when selecting a spreadsheet

Problem: When trying to select a spreadsheet in the file picker, you see an "API developer key is invalid" error. Despite the name, this is not an API key issue.

Fix: This is a known Google issue — it happens when you are not signed into the correct Google account in the same browser where you're using Coupler.io.

1. In the same browser where Coupler.io is open, open a new tab and go to Gmail or Google Drive. Sign in with the Google account you want to use.

2. Go back to Coupler.io, reload the page, and try selecting your spreadsheet again.

3. If you use multiple Google accounts, make sure the correct one is the active session in that browser. Google does not share login sessions between different browsers.

Missing data

"A specified worksheet/range was not found" error

Problem: The data flow fails with an error stating the worksheet or range was not found.

Fix:

1. Check that the sheet name in your configuration exactly matches the tab name in the spreadsheet — including capitalization and spaces.

2. Verify the range format is correct: use standard A1 notation (e.g., A:Z, A1:Z100). Do not include the sheet name in the Range field — it is set separately via the sheet selector.

3. If you renamed or deleted a sheet in the source spreadsheet, update the data flow to point to the new sheet name.

4. If using a regex pattern, test your pattern against the actual sheet names to confirm it matches at least one.

Only part of the data is exported — rows are missing

Problem: The export completes successfully but fewer rows are returned than expected.

Fix:

1. Check your Range setting. A fixed range like A1:Z100 only exports up to row 100 — use A:Z or A1:Z to include all rows.

2. If exporting multiple sheets, check whether all selected sheets have data. Empty sheets contribute zero rows.

3. Empty rows in the middle of the sheet are skipped. If there is an empty row separating two data blocks, rows below the empty row may not be exported.

4. Verify that the header row is in the first row of the range. If the first row is empty, the actual headers may be treated as data, and columns may be misaligned.

Data is truncated due to plan row limits

Problem: The export runs successfully but only returns a fraction of the rows in your spreadsheet — for example, only 100 or 1,000 rows.

Fix: Google Sheets is a metered source in Coupler.io. The number of rows you can pull per run depends on your billing plan:

• Free: 100 rows/run

• Personal: 1,000 rows/run

• Professional: 10,000 rows/run

• Team: 100,000 rows/run

• Business: unlimited

If your sheet has more rows than your plan allows, upgrade to a higher plan. Alternatively, split the data across multiple sheets and set up separate data flows for each, using Append mode in the destination.

Sheet Name column is missing from the output

Problem: When exporting multiple sheets, no Sheet Name column appears in the output.

Fix: The Sheet Name column is only added when two or more sheets are selected (or when a regex pattern matches multiple sheets). If only one sheet is selected — even via a pattern that matches only one sheet — the column is not added. Select at least two sheets or use a pattern that matches multiple tabs.

New sheets added to the spreadsheet are not being picked up

Problem: You've added new tabs to the spreadsheet but they don't appear in the export.

Fix:

1. If you selected sheets by name, you need to manually add the new sheet to the data flow configuration.

2. To automatically include new sheets, switch to a regex pattern that matches the naming convention of your sheets (e.g., Sales 202.+ for yearly sheets, .* for all sheets). Coupler.io will pick up any new sheets matching the pattern on the next run.

Data format issues

Dates are imported as text instead of date values

Problem: Date columns from the spreadsheet appear as text strings in the destination rather than proper date values.

Fix: The Google Sheets API returns cell values as strings when dates use custom formats that include text (e.g., 2025-01-12 (Mon)). Standard date formats work correctly (e.g., 2025-01-12, 10-Jan-2021, January 14, 2021).

Option 1 — Fix the format in the source spreadsheet: Change the custom date format in Google Sheets to a standard format without text components. Then apply your preferred display format in the destination file (Coupler.io does not override destination formatting).

Option 2 — Add a formula column in Coupler.io's Transformation step: Use the DATETIME_FORMAT formula to convert the text value. For example: DATETIME_FORMAT({Date}, 'YYYY-MM-DD')

Option 3 — Add a formula in the destination file: If you cannot change the source format, add a formula in the destination spreadsheet to parse the text date: =DATE(LEFT(A2,4), MID(A2,6,2), MID(A2,9,2))

Numbers are imported as text

Problem: Numeric columns arrive as text strings, causing issues with calculations or sorting in the destination.

Fix:

1. Check the cell format in the source spreadsheet — cells formatted as "Plain text" export as text even if they contain numbers. Change the format to "Number" or "Automatic" in Google Sheets.

2. Numbers with currency symbols (e.g., $1,234) or percentage formatting may arrive as strings. Strip formatting in the source or use a formula column in Coupler.io's Transformation step to convert.

Percentage formatting is lost after import

Problem: Cells formatted as percentages in the source spreadsheet lose their formatting in the destination — they appear as decimal values (e.g., 0.75 instead of 75%) or the destination formatting gets overwritten on each run.

Fix: Coupler.io exports raw cell values, not formatting. Percentage cells are exported as their underlying decimal value. Additionally, when writing to a Google Sheets destination, Coupler.io overwrites cell formatting on each run.

Workaround: Import data into a dedicated "raw data" sheet. Create a separate sheet that references the raw data using formulas (e.g., =RawData!A2) and apply your percentage formatting there. This formatting sheet won't be overwritten by Coupler.io.

Formula results are not exporting — seeing formula text instead of values

Problem: Cells containing formulas are exported as the formula string (e.g., =SUM(A1:A10)) rather than the computed result.

Fix: This typically happens when the cell is formatted as "Plain text" in Google Sheets, which prevents formula evaluation. Change the cell format to "Automatic" or the appropriate type. If the formula is in an array formula, make sure the array formula is not returning an error.

Timeouts

Timeout: "we could not import your data within 9 minutes"

Problem: The data flow fails with a timeout error, typically when the spreadsheet is very large or contains many complex formulas.

Fix:

1. Reduce the range — Instead of A:Z, use a more specific range that excludes empty columns (e.g., A:K if only 11 columns have data).

2. Split the export — If the sheet has many rows, consider splitting it into smaller sheets and setting up separate data flows for each.

3. Remove heavy formulas — Spreadsheets with many ARRAYFORMULA, QUERY, or IMPORTRANGE functions take longer to process. Consider replacing complex formulas with static values where possible.

4. Check for errors in the sheet — Formula errors (#REF!, #DIV/0!, etc.) can slow down Google Sheets API responses. Fix broken formulas before exporting.

5. For very large data (hundreds of thousands of rows), consider using a different source format (CSV or database) instead of Google Sheets.

Destination overwrites

These issues apply when Google Sheets is used as a destination (not just a source). Since Google Sheets is commonly used as both, these are among the most frequent support topics.

Coupler.io overwrites formulas and data to the right of the imported range

Problem: After each import, formulas, custom columns, or manually entered data to the right of the imported data disappear.

Fix: This is expected behavior. Coupler.io starts writing from the cell specified in the importer settings and replaces all data below and to the right of that cell.

To protect your formulas and custom columns:

1. Use a fixed destination range — Set the range to match your source columns exactly (e.g., A1:T if you have 20 columns). Coupler.io will only write within that range.

2. Place formulas to the left — Move custom columns to the left of the import start cell.

3. Use a separate "raw data" sheet — Import to a dedicated sheet, then reference it from a second sheet where you build formulas and dashboards. The reference sheet won't be touched by Coupler.io.

Multiple data flows overwrite each other in the same destination sheet

Problem: You have two or more data flows writing to the same Google Sheets tab, and one importer's data disappears when the other runs.

Fix: Data flows run in parallel and the execution order is not guaranteed. When two importers write to the same sheet in Replace mode, whichever runs last overwrites the other.

Solutions:

1. Write each importer to a separate sheet — then create a combined view sheet using ARRAYFORMULA or ={Sheet1!A:Z; Sheet2!A:Z} to merge the data.

2. Use fixed destination ranges — Set non-overlapping ranges for each importer (e.g., importer 1 writes to A1:H, importer 2 writes to J1:Q).

3. Use Append mode — If both data flows add rows to the same dataset, use Append mode so they don't overwrite each other. Be aware that Append accumulates rows on each run.

Google API errors

Google API 500 error — "Internal error encountered"

Problem: The data flow fails with a Google API 500 error.

Fix: This is a transient error from the Google Sheets API — it is not caused by Coupler.io. It typically occurs when:

• The Google Sheets API is temporarily unavailable or under maintenance

• The spreadsheet is overloaded, contains many heavy formulas, or has slow loading time

• The spreadsheet has formula errors or broken references

Steps to resolve:

1. Wait a few minutes and re-run the data flow. Transient API errors usually resolve on their own.

2. Open the source spreadsheet in Google Sheets and check for visible issues (slow loading, formula errors, broken references).

3. Try exporting a simpler test spreadsheet to confirm the issue is with the source file and not a general API outage.

4. If the error persists, copy the relevant sheet to a new spreadsheet and set up the data flow from the copy.

Google API "Service unavailable" error

Problem: The data flow fails with a "Service unavailable" error from the Google Sheets API.

Fix: This is a transient Google-side error, separate from the 500 "Internal error." It typically means the Google Sheets API is temporarily overloaded or under maintenance.

1. Wait 5–10 minutes and re-run the data flow. These errors almost always resolve on their own.

2. If the error persists across multiple runs, check the Google Workspace Status Dashboard for ongoing incidents.

3. If your spreadsheet is very large or formula-heavy, it may be contributing to the issue — try simplifying the sheet.

"Resource has been exhausted" — Google API quota error

Problem: The data flow fails with an error like "Resource has been exhausted (e.g. check quota)."

Fix: This means your Google account has hit the Google Sheets API rate limit. This is a per-user Google quota — not a Coupler.io limit. It typically happens when multiple tools, scripts, or data flows read from or write to the same spreadsheet heavily.

Coupler.io retries with exponential backoff (1s, 3s, 9s, 27s, 81s, ~4min) but gives up after approximately 6 attempts.

To resolve:

1. Reduce the number of tools and scripts accessing the same spreadsheet simultaneously.

2. Split the data across multiple spreadsheets to spread the API load.

3. If you have many Coupler.io data flows reading from the same file, stagger their schedules so they don't run at the same time.

4. Reduce the complexity of the source sheet — fewer formulas and smaller ranges generate fewer API calls.

Google Sheets FAQ

Can I export from multiple sheets in one data flow?

Yes. You can select multiple sheets from the same spreadsheet in a single data flow. Coupler.io merges the data by matching column headers — rows from all selected sheets are combined into one output table, and a Sheet Name column is added automatically so you can identify which tab each row came from.

To export from multiple spreadsheets (different files), you need a separate data flow for each spreadsheet. Then combine the outputs in your destination using Coupler.io's data append feature or by merging in your BI tool.

What is a regex sheet pattern and when should I use it?

A regex (regular expression) pattern lets you match sheet names dynamically instead of selecting them one by one. This is useful when you regularly add new tabs with a consistent naming convention and want Coupler.io to automatically include them on the next run.

For example, if you add a new monthly sheet every month (Sales Jan 2026, Sales Feb 2026, etc.), use the pattern Sales .+ to match all of them — including ones added in the future.

Common patterns:

Pattern	Matches
.*	All sheets
Sales .+	All sheets starting with "Sales "
.*2026.*	All sheets containing "2026"
.*summary	All sheets ending with "summary"

What range format should I use?

Use standard A1 notation:

• A:Z — All columns A through Z, all rows (open-ended, captures new rows)

• A1:Z — Columns A–Z, from row 1 to the last row with data

• A1:Z100 — Fixed range: columns A–Z, rows 1–100 only

• B2:E — Columns B–E, starting from row 2 (useful to skip a non-header first row)

For most use cases, A:Z is the best starting point — it captures everything and automatically includes new rows.

Does Coupler.io export formula values or the formula itself?

Coupler.io exports the computed value of formula cells, not the formula text. A cell containing =SUM(A1:A10) will export as the numeric result (e.g., 4250), not the formula string.

The exception is cells formatted as "Plain text" in Google Sheets — these may export the formula text. Change the cell format to "Automatic" or the appropriate data type in Google Sheets to export the computed value.

Why are my dates importing as text?

The Google Sheets API returns dates as text when they use custom formats that contain text components — for example, 2025-01-12 (Mon) or Monday, January 12.

Standard date formats export correctly: 2025-01-12, 10-Jan-2025, January 12, 2025.

To fix this:

1. Change the date format in the source spreadsheet to a standard format (recommended).

2. Or add a DATETIME_FORMAT formula column in Coupler.io's Transformation step to convert the text value.

See Common Issues for detailed steps.

Why is the data flow timing out?

Timeouts occur when the source spreadsheet is too large or too slow to process within the 9-minute limit. Common causes:

• Very large number of rows (hundreds of thousands)

• Many heavy formulas (IMPORTRANGE, ARRAYFORMULA, QUERY)

• Formula errors that cause recalculation loops

• Very wide ranges with many empty columns

To fix: narrow the range, reduce the number of columns, fix broken formulas, or split the sheet across multiple data flows.

See Common Issues for detailed steps.

Can I export from a spreadsheet shared with me by someone else?

Yes, as long as the connected Google account has at least Viewer access to the spreadsheet. The spreadsheet will appear in the file picker when you set up the data flow.

If the spreadsheet does not appear, ask the owner to share it with your Google account, or check that you're connected with the correct account in Coupler.io.

Can I export from a Google Sheets file in a Shared Drive?

Yes. As long as the connected Google account is a member of the Shared Drive (or the file is shared with the account directly), it will appear in the file picker. If the Shared Drive uses restricted access, your account must be a member of the drive — not just a recipient of a specific file link.

What happens if I rename or delete a sheet in the source spreadsheet?

If you selected the sheet by name and then rename it in Google Sheets, the data flow will fail with a "worksheet not found" error. Update the sheet name in the data flow configuration to match the new tab name.

If you're using a regex pattern, renaming a sheet may cause it to no longer match the pattern — or to start matching if it now fits the pattern.

If a sheet is deleted and it was explicitly selected, the data flow will fail. Remove the deleted sheet from the data flow configuration.

Why does the Sheet Name column not appear in my output?

The Sheet Name column is only added when two or more sheets contribute to the export. If only one sheet is selected (or your regex pattern matches only one sheet), no Sheet Name column is added. Select at least two sheets or adjust your pattern to match multiple tabs.

Can I use Google Sheets as both a source and a destination in the same Coupler.io account?

Yes. Coupler.io supports Google Sheets as both a source (pulling data from a spreadsheet) and a destination (writing data to a spreadsheet). You can even use different sheets within the same spreadsheet — for example, reading raw data from one tab and writing processed output to another.

Just make sure the source range and destination range do not overlap, as writing to a range that is also being read will cause data conflicts.

Why is Coupler.io overwriting my formulas and data in the destination sheet?

Coupler.io writes data starting from the cell specified in your importer settings and replaces everything below and to the right of that cell. This means formulas, manual entries, and custom columns in that area will be overwritten on each run.

To avoid this:

1. Set a fixed destination range (e.g., A1:T) so Coupler.io only writes within specific columns.

2. Move formulas to the left of the import start cell.

3. Use a dedicated "raw data" sheet and reference it from a separate sheet where you build formulas and dashboards.

See Common Issues for more details.

Why is only part of my data being exported — is there a row limit?

Row limits depend on the plan version you are using. For the new Coupler.io plans, row limits apply only to the Free and Starter plans. You can learn more on our pricing page. However, some legacy plans may still have row limits. For example, plans that were active before September 2025 had specific row limits for Google Sheets as a metered source:

• Free: 100 rows/run

• Personal: 1,000 rows/run

• Professional: 10,000 rows/run

• Team: 100,000 rows/run

• Business: unlimited

Plans purchased before August 2024 also have row limits, but they worked differently and apply to all sources, not only metered sources.

If your export seems incomplete and you are using a legacy plan, please contact our Support team so we can help you in checking the exact limits that apply to your subscription.

Can I set up multiple data flows writing to the same destination sheet?

You can, but be careful — data flows run in parallel and may overwrite each other if they target the same cell range in Replace mode.

Recommended approach: Write each data flow to a separate sheet tab, then combine them in a summary sheet using ARRAYFORMULA or ={Sheet1!A:Z; Sheet2!A:Z}. Alternatively, use fixed non-overlapping destination ranges for each data flow.

See Common Issues for detailed solutions.

How do I export only specific rows — for example, only rows where a column equals a certain value?

Coupler.io's Google Sheets source exports all rows in the selected range without row-level filtering at the API level. To export only specific rows:

1. Add a filter in Coupler.io's Transformation step to keep only rows matching your condition.

2. Or maintain a filtered view in a separate sheet within the source spreadsheet (using FILTER or QUERY formulas), and export from that sheet instead.