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?

Yes. 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 export seems truncated, check your plan's row limit on the pricing page. Upgrading your plan increases the per-run limit.

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.