FAQ

What is the CSV destination used for?

The CSV destination generates a stable HTTPS URL that serves your Coupler.io data as a CSV file. You can use this URL to feed data into spreadsheets, BI tools, databases, AI tools, custom scripts, or any application that supports CSV import or HTTP data fetching.

Does the URL change every time the data flow runs?

No. The URL stays the same across every run. Only the data it serves is updated. This means you can configure your downstream tool once and it will always fetch the latest data. If you click Update in the destination settings, a new URL is generated and the old one is invalidated.

Why do I get a 404 error when I open the CSV URL?

The URL returns a 404 until the data flow has completed at least one successful run. Go to your data flow, click Save and Run, and wait for the run to finish. After that, the URL will return data.

What does the Excel-friendly mode (BOM) setting do?

When enabled, this setting adds a byte order mark (BOM) at the beginning of the CSV file. The BOM tells Microsoft Excel to interpret the file as UTF-8, which ensures that special characters — accented letters, currency symbols, non-Latin scripts — display correctly. This setting is on by default. If you are not opening the file in Excel, you can safely disable it.

Some tools may display the BOM as an invisible character at the start of the file. If this causes issues in your downstream tool, disable Excel-friendly mode in the destination settings.

What does the Include headers setting do?

When enabled (the default), the first row of the CSV file contains column names. If you disable this setting, the file starts directly with data rows. Most tools expect headers in the first row, so keep this on unless your consuming tool specifically requires raw data without headers.

Is there an Append mode for the CSV destination?

No. The CSV destination only supports Replace mode — each run overwrites the data at the URL with the latest export. If you need to accumulate historical data over time, consider using a database destination like BigQuery or PostgreSQL instead.

Can I use the CSV URL with Google Sheets?

Yes. In Google Sheets, use the =IMPORTDATA("your-csv-url") formula to pull data directly from the CSV URL. The data will refresh each time Google Sheets recalculates or when you manually trigger a refresh.

Can any Coupler.io source send data to the CSV destination?

Yes. The CSV destination works with any source available in Coupler.io, including HubSpot, Google Ads, Facebook Ads, Pipedrive, Airtable, and more. You can also combine multiple sources in a single data flow using Join, Append, or Aggregate transformations.

Is the CSV URL secure?

The URL includes an access token that controls who can read the data. Anyone with the full URL can access the exported data, so treat it like a password. Avoid posting it in public places. If the token is compromised, click Update in the destination settings to generate a new URL.

How do I test that my CSV URL is working correctly?

Paste the URL into a browser — it will download the CSV file. You can also use an HTTP client like Postman or curl to fetch the data. If you see a 404, the flow hasn't run yet, or the URL has been regenerated.