# Pipedream

This integration lets you trigger Pipedream automations in real time whenever a spreadsheet import is submitted — perfect for connecting data to your APIs, CRMs, or databases without writing custom code.

***

#### How It Works

CSVBox sends the imported CSV data to your selected Pipedream workflow as soon as a user submits it. Each import becomes a new event in Pipedream, where you can process or forward the data to hundreds of apps.

***

#### Example workflow:

1. User uploads CSV → CSVBox validates and sends data to Pipedream
2. Pipedream trigger receives the event
3. The workflow inserts rows into a database, sends Slack alerts, or posts data to your API

***

#### Setup Instructions

**Step 1: Choose Pipedream as your destination**

In your CSVBox **Sheet Settings**, select **Pipedream** as the destination and click **Save**.

**Step 2: Create a Pipedream trigger**

1. Log in to your [Pipedream account](https://pipedream.com/).
2. Create a **new workflow**.
3. When prompted to select a trigger source, choose **CSVBox > New Import**.

<figure><img src="https://1907234374-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MN8YRAnfnCaoVVZflQz%2Fuploads%2FlNDB0yiCXTNqxRmLaYij%2F1trigger.png?alt=media&#x26;token=ecf48b31-2bca-4c85-9b1c-69e3775c135d" alt=""><figcaption></figcaption></figure>

**Step 3: Connect CSVBox to Pipedream**

In the trigger setup screen, paste your **CSVBox API Key** and **API Secret Key**. You can find these under **CSVBox Dashboard → Account Settings → API Keys**.

<figure><img src="https://1907234374-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MN8YRAnfnCaoVVZflQz%2Fuploads%2Fl0uhWEqqPvghqDSXLaPD%2Fconnect%20CSVbox%20.png?alt=media&#x26;token=4f56e50d-6a4f-4617-b560-be5da9195ed9" alt=""><figcaption></figcaption></figure>

**Step 4: Select your Sheet**

In the **Trigger Settings** window in Pipedream, choose the **Sheet Name** you want to connect from the dropdown.\
Click **Save and contine** to confirm.<br>

<figure><img src="https://1907234374-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MN8YRAnfnCaoVVZflQz%2Fuploads%2FIakt2jsuUNIUULF1VG6Y%2Fslect%20sheet.png?alt=media&#x26;token=ad26089b-77e7-4bd8-8b67-480a9da05a63" alt=""><figcaption></figcaption></figure>

**Step 5: Verify the connection**

Return to **CSVBox → Sheet Settings → Destination**.\
The **Pipedream Connection** should now show as **successful**.<br>

<figure><img src="https://1907234374-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MN8YRAnfnCaoVVZflQz%2Fuploads%2FPfTEmKq8x10r9ccNzgbE%2Fconnection%20successful.png?alt=media&#x26;token=1cd9e090-4c2b-444f-86a6-245aed0793e1" alt=""><figcaption></figcaption></figure>

**Step 6: Test the importer**

* Upload a sample CSV using your importer.
* Pipedream will instantly receive the data as an event payload.
* You can view the incoming event in your Pipedream workflow’s **Event** tab.

{% hint style="info" %}
After making changes in your Pipedream workflow (such as reconnecting CSVBox or editing the trigger), wait for **a few seconds** before testing from CSVBox. It can take a short time for Pipedream to **propagate configuration updates** across their servers.
{% endhint %}

***

#### Common Use Cases

* **Sync leads to your CRM** (HubSpot, Salesforce, Pipedrive, etc.)
* **Insert or update records** in databases (PostgreSQL, MySQL, Supabase, Airtable)
* **Send notifications** on Slack, Discord, or Email
* **Transform or enrich data** before passing it to another service

***