> For the complete documentation index, see [llms.txt](https://docs.coupler.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coupler.io/sources/category/files-and-tables/dropbox.md).

# Dropbox

Automate CSV and Excel exports from Dropbox to Google Sheets, BigQuery, or AI tools via Coupler.io — no coding needed.

Dropbox is a cloud storage platform that lets you store and organize files. With Coupler.io, you can automatically export data from CSV and Excel files stored in Dropbox to Google Sheets, Excel, BigQuery, Looker Studio, or AI destinations like Claude and ChatGPT — on whatever schedule works for you.

## Why connect Dropbox to Coupler.io?

* **Automate data syncing** — Keep your spreadsheets in sync with Dropbox files without manual copying and pasting
* **No coding required** — Set up a data flow in minutes using our visual interface
* **Flexible scheduling** — Run imports on-demand or set them to refresh daily, weekly, or monthly
* **Combine multiple sheets** — Pull data from multiple sheets in the same file or different files and append them into one destination
* **Integrate with your tools** — Send data to Google Sheets, Excel, BigQuery, or use AI tools like ChatGPT for analysis

## Prerequisites

* A Dropbox account with access to the CSV or Excel files you want to import
* A destination ready to receive the data (Google Sheets, Excel, BigQuery, Looker Studio, Claude, ChatGPT, Cursor, Gemini, Perplexity, or OpenClaw)

## Quick start

{% hint style="success" %}
Start with a single file and one or two sheets to test your setup. Once you confirm the data looks right, you can add more sheets or files to the same data flow.
{% endhint %}

## How to connect

{% stepper %}
{% step %}
**Sign in to your Coupler.io account** and create a new data flow. Select **Dropbox** as your source.
{% endstep %}

{% step %}
**Click "Connect to Dropbox"** to authorize Coupler.io. You'll be asked to sign in to Dropbox and grant permission. If you have multiple Dropbox accounts, make sure you're signed in to the one containing your files — if needed, switch accounts in your browser before connecting.
{% endstep %}

{% step %}
**Select the file** you want to import using the file picker. This can be a CSV or Excel file stored anywhere in your Dropbox.
{% endstep %}

{% step %}
**Choose the sheet(s)** you want to pull data from. You can select multiple sheets — data from all of them will be appended into a single table in your destination. If you know a sheet name that doesn't exist yet but will be added later, you can type it in and Coupler.io will automatically fetch from it once it's created.
{% endstep %}

{% step %}
**Set a range (optional)** if you only want to import a specific section of the sheet, like A1:Z100. Leave this blank to import all data.
{% endstep %}

{% step %}
**Choose your destination** — Google Sheets, Excel, BigQuery, Looker Studio, or an AI tool like Claude or ChatGPT.
{% endstep %}

{% step %}
**Map your columns** and run a manual test to confirm the data looks correct before setting up any recurring schedule.
{% endstep %}
{% endstepper %}

## Supported file types

| File Type                                 | Supported |
| ----------------------------------------- | --------- |
| CSV                                       | ✓         |
| Excel (.xlsx, .xls)                       | ✓         |
| Google Sheets (shared via Dropbox export) | ✓         |
| Images, PDFs, other file types            | ✗         |

## Dropbox data overview

Dropbox doesn't expose predefined entities or metrics — instead, you control exactly which files and sheets to import. Coupler.io reads the data as-is from your CSV or Excel files.

## What data can you import?

**Columns and rows from your spreadsheet** — Coupler.io imports whatever columns and rows exist in the sheet(s) you select. Headers become column names, and each row becomes a record.

**Multiple sheets at once** — If you select more than one sheet from a file (or from multiple files), all data is automatically appended together into a single table in your destination. This is useful when you have data split across monthly sheets, different categories, or separate files.

**Custom ranges** — You can limit imports to a specific range (e.g., A1:Z50) if you only need part of the sheet.

## Common use cases

* **Consolidate data from multiple Excel files** — Pull data from 10 different Dropbox files into one Google Sheet
* **Sync live data** — Refresh your Google Sheet daily from an Excel file your team updates in Dropbox
* **Append monthly data** — Import data from 12 monthly sheets into one master sheet for annual reporting
* **Feed AI analysis** — Send Dropbox spreadsheet data to Claude or ChatGPT for insights, summaries, or processing
* **Archive to data warehouse** — Automatically load Dropbox files into BigQuery for long-term storage and analysis

{% tabs %}
{% tab title="Marketing teams" %}
Pull campaign performance data from Dropbox-stored Excel files into Google Sheets for real-time dashboards. Combine data from multiple regional files into one master sheet, then connect to Looker Studio for visualization. Use Append transformation to merge monthly reports into a single view.
{% endtab %}

{% tab title="Finance teams" %}
Sync expense reports, invoices, or budget spreadsheets from Dropbox to Google Sheets or BigQuery. Use Append to consolidate data from multiple departments or time periods. Schedule daily refreshes to keep your financial records current without manual copy-paste.
{% endtab %}

{% tab title="Sales ops" %}
Automate the export of CRM data (if exported to Dropbox as CSV) into your sales dashboard. Combine sales pipeline data from multiple team members' files into one source of truth in Google Sheets. Schedule weekly refreshes to stay aligned with real-time pipeline changes.
{% endtab %}

{% tab title="Product & data teams" %}
Automatically load user feedback, analytics, or usage data from Dropbox CSVs into BigQuery or your data warehouse. Feed cleaned data to Claude or Gemini for automated analysis and insights. Use Append to combine data across different time periods or data sources.
{% endtab %}
{% endtabs %}

## Platform-specific notes

* **Dropbox file picker** — If you can't see your file in the file picker, you may need to switch Dropbox accounts in your browser before connecting. Once you've authorized the correct account, refresh the file picker.
* **Excel formulas** — Coupler.io imports cell values, not formulas. If your Excel file contains formulas, you'll see the calculated results, not the formula text.
* **Images and embedded content** — Images, charts, and other embedded objects in your spreadsheet are not imported — only text and numeric data is extracted.
* **File comments** — Dropbox file comments are not supported; only the spreadsheet content itself is imported.
* **Large files** — Files over a certain size may take longer to process. If you're importing hundreds of thousands of rows, consider splitting into multiple smaller data flows or using a data warehouse like BigQuery as your destination.

## Dropbox common issues

### Connection issues

<details>

<summary>I can't find my file in the file picker</summary>

This usually means you're connected to the wrong Dropbox account. Coupler.io shows files from the Dropbox account you authorized during setup.

**Fix:** Sign out of all Dropbox accounts in your browser, then sign back in to the account that contains your file. Return to Coupler.io, refresh the file picker, and try again. If you need to switch accounts, you may need to disconnect and reconnect Dropbox in your Coupler.io account settings.

</details>

<details>

<summary>"File is no longer available to the current connection"</summary>

This error appears when the Dropbox connection has expired or the file has been moved/deleted since you set up the data flow.

**Fix:**

1. Check that the file still exists in Dropbox at the same location
2. If the file was moved, update the file selection in your data flow
3. If the connection has expired, disconnect Dropbox and reconnect by clicking "Connect to Dropbox" again in your data flow settings

</details>

<details>

<summary>I'm seeing a login screen when I try to connect</summary>

Dropbox is asking you to authenticate. Make sure you're signing in with the account that has access to the files you want to import.

**Fix:** Sign in with your Dropbox credentials and grant Coupler.io permission to access your files. If you're having trouble, try clearing your browser cache or using an incognito window.

</details>

### Missing data

<details>

<summary>Only part of my spreadsheet is being imported</summary>

You may have set a custom range (like A1:Z100) that's limiting the import, or the sheet contains blank rows that are being skipped.

**Fix:**

1. Check your data flow settings and look at the "Range" field
2. If a range is set and you want all data, clear it
3. Ensure your spreadsheet has headers in the first row — data without headers may not import correctly
4. Run a manual test to see exactly what's being pulled

</details>

<details>

<summary>Columns are missing from my import</summary>

This can happen if columns are formatted strangely, hidden, or contain only blank values.

**Fix:**

1. Open the original file in Dropbox and verify the columns exist and contain data
2. Check that no columns are hidden in the spreadsheet
3. If using a custom range, make sure all columns you need are included in the range (e.g., A1:Z100 covers columns A through Z)
4. Run a manual test to see which columns are being detected

</details>

<details>

<summary>Data from multiple sheets isn't being appended</summary>

You may have selected only one sheet, or the sheets have different column structures.

**Fix:**

1. Return to your data flow and select all sheets you want to import
2. Ensure all sheets have the same column headers in the same order — if column names differ, Coupler.io treats them as separate columns
3. If sheets have different structures, consider running separate data flows or aligning the sheet headers first

</details>

### Permission errors

<details>

<summary>"Permission denied" or "Access forbidden"</summary>

The Dropbox account you're connected with doesn't have permission to access the file.

**Fix:**

1. Verify you're signed in to the correct Dropbox account (the one with access to the file)
2. If the file is shared with you, make sure the sharing permission level allows reading/access
3. Disconnect Dropbox and reconnect with the account that has the proper permissions

</details>

### Data discrepancies

<details>

<summary>Formula values aren't appearing in my destination</summary>

Coupler.io imports the calculated value of a formula, not the formula itself. However, sometimes calculated values may not display correctly if the spreadsheet isn't saved in the right format.

**Fix:**

1. Save your Excel file in .xlsx format (not .xls or other formats)
2. Open the file in Excel or Excel Online and ensure formulas are recalculated and saved
3. Run a manual test in Coupler.io to see if the values now appear
4. If using a Google Sheet exported to Dropbox, ensure it was exported with current values calculated

</details>

<details>

<summary>Numbers are being imported as text</summary>

This happens when your spreadsheet cells are formatted as text instead of numbers, or if your CSV uses a comma as a decimal separator.

**Fix:**

1. In the original spreadsheet, select the numeric columns and change their format to "Number"
2. Re-save the file and run another import
3. If using a CSV, check that your locale settings match (e.g., comma vs. period for decimals)
4. In your destination, you can also format columns after import

</details>

<details>

<summary>Dates are showing incorrectly in my destination</summary>

Date formats can vary by locale and spreadsheet application. Coupler.io imports the date value but your destination may interpret it differently.

**Fix:**

1. In your Dropbox spreadsheet, ensure dates are formatted as actual date cells (not text)
2. After import, manually format the date columns in your destination to match your preferred format
3. If dates are still wrong, check your Coupler.io account timezone settings

</details>

### Rate limits

<details>

<summary>My data flow is running slowly or timing out</summary>

Large files or frequent refreshes can cause slowdowns. Dropbox rate limits may also apply if you're running many data flows simultaneously.

**Fix:**

1. If importing a very large file (100,000+ rows), consider splitting it into smaller ranges or files
2. Avoid running multiple data flows on the same Dropbox account at the same time
3. Space out scheduled refreshes — instead of running every 15 minutes, try hourly or daily
4. Use a data warehouse like BigQuery as your destination for better performance with large datasets

</details>

## Dropbox FAQ

<details>

<summary>Can I import from multiple Dropbox files in one data flow?</summary>

Yes, but you'll need to set up separate data flows for each file. However, you can use the Append transformation in Coupler.io to combine data from multiple data flows into a single destination. This is useful when you have data split across different files.

</details>

<details>

<summary>What happens if I move a file in Dropbox after setting up a data flow?</summary>

The data flow will break and show a "file is no longer available" error. To fix it, you'll need to update the file selection in your data flow settings to point to the new location. To avoid this, keep your Dropbox file in the same folder after setting up the import.

</details>

<details>

<summary>Can I import Excel formulas?</summary>

No, only the calculated values are imported. If your Excel file contains a formula like =SUM(A1:A10), Coupler.io will import the result (e.g., 150) but not the formula itself. If you need formulas in your destination, you'll have to recreate them there.

</details>

<details>

<summary>Can I import images or charts from my Dropbox spreadsheet?</summary>

No, Coupler.io only extracts text and numeric cell data. Images, charts, comments, and other embedded objects are not imported. Only the spreadsheet content itself is transferred.

</details>

<details>

<summary>How do I append data from multiple sheets into one table?</summary>

When setting up your data flow, select all the sheets you want to combine in the "Sheet(s)" field. Coupler.io will automatically append all data from those sheets into a single table in your destination. Make sure all sheets have the same column headers for best results.

</details>

<details>

<summary>Can I use a custom date range to import only recent data?</summary>

Yes, use the "Range" field to specify which rows to import (e.g., A1:Z500). However, if you need to import only rows updated after a certain date, you'll need to filter the data in your Dropbox file first or use a data warehouse like BigQuery and apply filters after import.

</details>

<details>

<summary>What file formats does Coupler.io support?</summary>

CSV and Excel files (.xlsx, .xls) are fully supported. Google Sheets exported to Dropbox as a file will also work. PDFs, images, and other file types are not supported.

</details>

<details>

<summary>Do I need a Business plan to import from multiple Dropbox files?</summary>

You need multiple data flows (one per file), which is available on all plans. However, the number of "connections" you can create may depend on your plan. Each Dropbox file you want to import from counts as one connection. Check your plan details or contact Coupler.io support to confirm your limits.

</details>

<details>

<summary>Can I automatically sync data between Dropbox and Google Sheets?</summary>

Yes. Set up a data flow from Dropbox to Google Sheets, then schedule it to refresh daily, weekly, or at any interval you need. Each time the flow runs, your Google Sheet will be updated with the latest data from your Dropbox file.

</details>

<details>

<summary>What should I do if my data is importing very slowly?</summary>

For large files with hundreds of thousands of rows, consider splitting the import into multiple smaller data flows or using a specific range (e.g., A1:M10000) instead of the entire sheet. You can also use BigQuery as your destination, which is optimized for large datasets. Avoid running multiple Dropbox data flows at the same time — stagger them to reduce load.

</details>

{% hint style="info" %}
For more details on what data is available and how to structure multi-sheet imports, see the [Data Overview](#dropbox-data-overview). For connection troubleshooting, check [Common Issues](#dropbox-common-issues).
{% endhint %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.coupler.io/sources/category/files-and-tables/dropbox.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
