---
description: >-
  Learn how to efficiently export data from Google Sheets back to Trello using
  Dokin.
---

# Push Back Data from Google Sheets to Trello

## Step 1: Connect Trello Data Using Dokin

Before you can push data back from Google Sheets to Trello, you need to establish a connection between the two platforms.

➡️ Follow [**this tutorial**](connecting-trello-data-using-dokin) to learn how to connect Trello using Dokin.



## Step 2: Write Data in Your Spreadsheet&#x20;

### Common Warning

Before pushing data to Trello, it's essential to understand a few key points:

* **Read-only fields.** Some fields in your Google Sheets are read-only, indicated by a grey background. Any data written in these columns will not be updated in Trello and will be disregarded.
* **Fields with options:** For columns with predefined options, ensure that the data you enter matches one of the available options; otherwise, you may encounter errors.

### Case 1: Updating an imported Card

If you wish to update an existing Trello card, simply overwrite the data in the corresponding row of your spreadsheet.

<figure><img src="https://4155748457-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlqAYxzBJs5gwjCJbSRPE%2Fuploads%2F8DMqzA6TSVHXFJrGL2qh%2Fezgif-4-11d064637b.gif?alt=media&#x26;token=418ce20a-1db0-4704-b5ca-13664cc9d964" alt=""><figcaption><p>Overwrite data to update a record</p></figcaption></figure>

### Case 2: Creating a new Card

To create a new Card, simply write data in a new row of your spreadsheet. Leave the column "ID" blank. An ID will be automatically generated when Card is created.&#x20;

<figure><img src="https://4155748457-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlqAYxzBJs5gwjCJbSRPE%2Fuploads%2FPUxjfXguVREzzhW3oLyx%2Fezgif-4-270108c645.gif?alt=media&#x26;token=1c371db3-b61f-4a25-92dd-040cad8288d3" alt=""><figcaption><p>Write data in a new row to create a record</p></figcaption></figure>

## Step 3: Push data back to Trello

Once you are satisfied with the data you want to transfer, proceed with the following steps:

* On the corresponding Connection, click on the Options icon
* Click on the menu item "Push Data back to Trello"

<figure><img src="https://4155748457-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlqAYxzBJs5gwjCJbSRPE%2Fuploads%2FnlPogXELJBUgtNPUvGmX%2Fimage.png?alt=media&#x26;token=26dd698b-46dc-471e-a30f-338a787cd645" alt=""><figcaption><p>Select "Push Data back" option</p></figcaption></figure>

A pop-up window will appear to confirm your intent to push data back to Trello. If you're ready to proceed, click on "Push."&#x20;

**Dokin will then perform the following checks:**

**Case 1: Records Without IDs**

If some records in your spreadsheet do not have an ID, Dokin will detect this and ask if you want to create new entries for records without IDs. You can choose to check or uncheck this option based on your preference.

<figure><img src="https://4155748457-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlqAYxzBJs5gwjCJbSRPE%2Fuploads%2FRmSDrX2zazG1dRWhlXaK%2Fimage.png?alt=media&#x26;token=ac5fbece-71a8-481f-ac98-89af9a87fbab" alt=""><figcaption><p>Check the box if you want Dokin to crate new records</p></figcaption></figure>

**Case 2: Fields That Do Not Match**

If any headers in your spreadsheet do not match with Trello fields, you will need to select the appropriate Trello field that corresponds to the column. Ensure that all fields are correctly mapped for a successful data transfer.

<figure><img src="https://4155748457-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlqAYxzBJs5gwjCJbSRPE%2Fuploads%2Fhida5l7luvX8AH5H0gT7%2Fimage.png?alt=media&#x26;token=507a3711-aeac-4eac-a9d1-1645014f331b" alt=""><figcaption><p>Map each incorrect field name with the corresponding one</p></figcaption></figure>



**By following these steps, you can effortlessly export data from Google Sheets to Trello using Dokin, streamlining your workflow and ensuring accurate data integration between these two essential tools.**

