![](https://assets-global.website-files.com/645912ad6182145b7d930abe/6488785e33af808a5e43309a_gsheet-pg-thumbnail.png)
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
![](https://assets-global.website-files.com/645912ad6182145b7d930abe/6487c26d02b4544a36b8899a_postgres-1.png)
2. Connect Postgres
![](https://assets-global.website-files.com/645912ad6182145b7d930abe/6487c2d34e4c6422f5f2cd10_postgres-2.png)
3. Enter details found in connection URI, password, and preferred security settings
![](https://assets-global.website-files.com/645912ad6182145b7d930abe/6487c2e493a1a6d6bb727bca_postgres-3.png)
4. Write a query or send a full table from Postgres
![](https://assets-global.website-files.com/645912ad6182145b7d930abe/6487c32cc3473ff5e526cda9_postgres-4.png)
5. Connect to Google Sheets
![](https://assets-global.website-files.com/645912ad6182145b7d930abe/64887d91f953e3c4f75cc148_gsheet-1.png)
6. Add a Google Sheet account
![](https://assets-global.website-files.com/645912ad6182145b7d930abe/64887dbc079693cfbffa84d7_gsheet-2.png)
7. Grant access to the base
![](https://assets-global.website-files.com/645912ad6182145b7d930abe/64887de19c6ab83eafd14f20_gsheet-3.png)
8. Select the spreadsheet
![](https://assets-global.website-files.com/645912ad6182145b7d930abe/64887e1fa5a3d240d14e0ab2_gsheet-4.png)
9. Select a column with unique values in each row in the Primary Key field
![](https://assets-global.website-files.com/645912ad6182145b7d930abe/64887e42ec4bbea498d874e1_gsheet-5.png)
10. Click continue
11. Choose the direction to sync data in
![](https://assets-global.website-files.com/645912ad6182145b7d930abe/64887e60c10d8d5d0eaffd50_gsheet-pg-direction.png)
12. Map the fields in Google Sheets to the fields in Postgres
![](https://assets-global.website-files.com/645912ad6182145b7d930abe/64887e82c10d8d5d0eb03cb6_gsheet-pg-mapping.png)
13. Choose how often the data should refresh
![](https://assets-global.website-files.com/645912ad6182145b7d930abe/6487c6bd805ae194315c0d83_sync-frequency.png)
14. Turn the toggle on to get syncing
![](https://assets-global.website-files.com/645912ad6182145b7d930abe/6487c6c579eff354ceca788b_active-toggle.png)