How To

How to sync Google Sheets and Postgres

Ian Yanusko
June 13, 2023
min read

If Postgres takes priority, choose Postgres as your primary source and Google Sheets as your secondary source. Otherwise, do the opposite

1. Choose your primary source

2. Connect Postgres

3. Enter details found in connection URI, password, and preferred security settings

4. Write a query or send a full table from Postgres

5. Connect to Google Sheets

6. Add a Google Sheet account

7. Grant access to the base

8. Select the spreadsheet

9. Select a column with unique values in each row in the Primary Key field

10. Click continue

11. Choose the direction to sync data in

12. Map the fields in Google Sheets to the fields in Postgres

13. Choose how often the data should refresh

14. Turn the toggle on to get syncing