<aside> 💡 The database user for this source will need write access to the database. If you need to add / insert rows, consider using a Forms instead

</aside>

You can sync data from a Google Sheet back to your database using the Google Sheets Addon, to get started, install the addon. Updates are triggered as soon as an edit in the Sheet is completed, so the updates write back to your database in near real time.

https://www.youtube.com/embed/KOrIT5jqQLI

  1. Create a new SQL block with Parameters. It's best to give the parameter the same name as the column, e.g.

    update dummy.users 
set plan = '{{plan}}' 
where email = '{{email}}'

  2. Add the form tag

  3. Launch the addon

  4. Select the block created in step #1 (you should see "Form" to the right of it)

  5. Click "Set up a sync" under the Run button

  6. Add the range that your data is in, e.g. "Sheet1!A:G". You need to include the cell range using A1 notation. Your table in sheets needs to have headers / column names

    <aside> 💡 You can only have one sync per sheet, but you can have multiple syncs in the same spreadsheet.

    </aside>

  7. If the table in Sheets has different column names then your parameters, specify the names under each parameter name.

  8. Click Save

  9. Done! You can now test your sync by updating a value in the Sheet and confirming the write back to your database. Please let us know if you run into any issues with this.

Tips and Tricks

Upserts