How To

How to sync Google Sheets and MySQL

Ian Yanusko
June 13, 2023
min read

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

1. Choose your primary source

2. Connect MySQL

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

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

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 MySQL

13. Choose how often the data should refresh

14. Turn the toggle on to get syncing