• Connecting to Postgres or MySQL

  SyncWith has built in Google Sheets integrations for Postgres or MySQL databases. You can run arbitrary SQL and have it import directly into your Google Sheet. Connection Strings The easiest way to connect to your database is with a connection string. Most web hosting companies will provide you with a connection string in the admin UI. It will look something likePopular

• Pull dynamic values from Google Sheets in your Postgres or MySQL query

  SyncWith for Google Sheets has a feature called Cell References which you can use in an SQL query to pull value(s) from your sheet. This can be useful to pull dynamic values that might change, for example a date. Cell references can reference a single cell, or a row or column range of cells, or a named range. Example cell reference syntax: Sheet1!A1 'Sheet name'!A1:A2 NameOfYourNamedRange Here's an example of using one in your SQL:Few readers

• PostgreSQL timeout

  By default, we have a 30-minute timeout for any report created. If your PostgreSQL query is taking longer than 30 minutes to execute the connection will be automatically interrupted and you'll see a TIMEOUT error in SyncWith. You should try to optimize your query to run more quickly, using tools like EXPLAIN ANALYZE, and then update your SyncWith report to use the optimized query.Few readers