SyncWith can connect to your Postgres or MySQL database. You can run arbitrary SQL and have it import directly into your Google Sheet.
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 like
Static IP Addresses
If your database is protected by network security, you can whitelist SyncWith’s static IP addresses to enable SyncWith to access your database securely:
You may need to adjust settings on your database server to permit SyncWith to communicate with it.
ENOTFOUND often means that you are using an internal hostname. SyncWith needs an external hostname.
Internal hostnames often look like:
justahost(an external hostname include a domain, for example:
You may need to ask your hosting provider for assistance.
ETIMEDOUT often means that your database is blocking us at the network level via firewall rules. You will need to permit access to SyncWith’s static IP addresses (see above).
ECONNREFUSED means the connection was refused, this could be because the host is incorrect, or the port is incorrect, or it could also be because the host is blocking us at the network level. Please check your host and port, if they are correct then you might need to permit access to SyncWith’s static IP addresses (see above).
EAI_AGAIN is typically a DNS configuration issue, sometimes its temporary, please consider using a tool like https://intodns.com/ to check your DNS configuration.
More API Database Connector Tutorials
- How to connect mysql to google sheets to sync data to a sheet
- Using SyncWith to connect postgres to google sheets