Integrate Google Cloud SQL for PostgreSQL with Autopilot for Automated Data Sync

About Google Cloud SQL for PostgreSQL

Google Cloud SQL for PostgreSQL is a fully-managed database service that makes it easy to set up, maintain, manage, and administer your relational PostgreSQL databases in the cloud.

About Autopilot

Autopilot is a visually-focused marketing software that provides tools for automating a customer’s journey. These include custom triggers that can be mapped out and automated ahead of time so that you can send the right kind of follow-up communications to the right customers. Autopilot can also automatically capture visitors, segment contacts using pre-established filters, and track the progress that a company is making towards a marketing goal. This allows users to make modifications that increase efficiency in real time.

Popular Use Cases

Bring all your Autopilot data to Amazon Redshift

Load your Autopilot data to Google BigQuery

ETL all your Autopilot data to Snowflake

Move your Autopilot data to MySQL

Autopilot's End Points

Autopilot Contacts

Manage your contacts by updating, deleting, or retrieving contact data, including names, emails, phone numbers, the source of the lead and their affiliated company. With this information, you can more easily segment each contact into appropriate groupings that will make your marketing more targeted and effective.

Autopilot Smart Segments

Retrieve a list of existing smart segments, including the names and IDs for those segments. Then, gather data from a single smart segment to see relevant contact information, including how many contacts are grouped into that segment and who the first 100 contacts are. You will also get a bookmark link to the next batch of contacts, should there be more.

Autopilot Journeys

Get a list of Autopilot journeys that have API triggers, which includes their names and trigger IDs. Then, use that trigger to automatically add a contact to a journey via the contact’s ID or email address.