FAQ

What's the difference between Replace and Append mode?

Replace deletes all previously imported data in the target area and writes fresh data from your source on every run. Use this when you want your sheet to always reflect the current state of your source — for example, a live CRM contacts list.

Append adds new rows below the existing data without touching what's already there. Use this when you want a running history — for example, daily ad spend records where you never want to lose older entries.

If you're using Append and want to avoid duplicates, make sure your source query filters to only new data (e.g., records created since the last run).

How do I keep my formulas safe when Coupler.io imports data?

Set your cell address to a column that leaves space for your formulas. Coupler.io writes data to the right starting from the cell you specify, so placing formulas in columns to the left of the start cell keeps them untouched.

For example, if you set the cell address to C1, columns A and B are completely free for your own formulas and labels.

Can I target a specific cell range instead of writing from a single starting cell?

Yes. Instead of a single cell like A1, you can enter a range like C1:F50 in the cell address field. This tells Coupler.io to write only within those boundaries — useful when you want imported data sandwiched between existing columns.

Just make sure the range is large enough for your data. In Replace mode, any data outside the defined range will be cut off.

See the Update Google Sheets destination without data overwriting article for a full table of supported range formats and examples.

Can I create a new sheet tab automatically on every run?

Yes — use a macro in your destination sheet name. For example, entering orders_{{today}} as the sheet name will create a new tab named with today's date on each run. Pair this with a daily schedule and you get one organized tab per day automatically.

Coupler.io supports several macros for dynamic naming. Check the dedicated macros guide for the full list of options.

Do not use date macros like {{today}} if you just want data refreshed in the same sheet — that will create a new tab on every run rather than updating the existing one.

Can I import data from multiple sources into the same Google Sheet?

Yes, in two ways. First, a single data flow supports multiple sources — you can combine them using Join, Append, or Aggregate transformations before sending the result to one sheet tab. Second, you can create separate data flows that each write to different tabs within the same spreadsheet.

Will Coupler.io overwrite data in cells I didn't intend to change?

In Replace mode, Coupler.io clears and rewrites everything starting from your defined cell or range. It does not touch cells outside that area. To protect specific columns, place them to the left of your start cell or use a range that deliberately excludes them.

Why does my imported data show fewer rows than my source?

The most common cause is a defined cell range that's too small. If you entered a range like A1:D20 and your source has 50 rows, only 20 rows will be written. Switch to a single starting cell (e.g., A1) to let Coupler.io write all rows without a ceiling.

If you're not using a restricted range and data is still missing, check whether your source filters are narrowing the result set, or contact Coupler.io support with your data flow name.

Does Coupler.io support Google Sheets in shared drives (Team Drives)?

Yes, as long as the Google account connected to Coupler.io has Editor access to the shared drive spreadsheet. Make sure the account's permissions in the shared drive allow file editing, not just viewing.

Can I rename or reorder the columns that Coupler.io writes to my sheet?

Column names and order are determined by your source data and any transformations you apply in Coupler.io before the destination step. You can use the Data set step in the data flow setup wizard to filter, reorder, or rename columns before they reach Google Sheets.

What happens to my sheet if the data flow fails mid-run?

In Replace mode, Coupler.io performs the write as an atomic operation — if the run fails, the previous data remains in place and is not partially overwritten. In Append mode, any rows already written during the failed run may remain; check for duplicates if you retry.