ConditionalVisibility

new-products-promo

Ramit Sethi talks to the IWT team

Show PostgreSQL data in Periscope Data charts

email conformation data in PostgreSQL via Periscope 

payment data in a periscope data chart

Double opt-in email addresses

IWT team

Customer stories

content-management-data-automa primary img

Infusionsoft

PostgreSQL

Data is worthless without analysis. You can collect all the numbers you want; but if you don’t unpack the "how" and "why" behind those facts, you’re left with a list of info that might as well be random.

How a Content Company Uses Zapier to Learn From Their Email Marketing Data

Keeping your contacts at hand on your CRM is essential, but these aren't easily accessed or searched by the rest of your system. Let us ensure your database health so every part of your business can access what it needs: After you've set up this automation, it will react to every new contact you add to Keap Max Classic, adding their personal details to a new row on a PostgreSQL table for you to query as needed.

Keap Max Classic is all-in-one marketing and sales automation software for small businesses. It effortlessly combines CRM, email marketing and e-commerce.

Keap Max Classic

Triggers when a new action sequence is added.

New Action Sequence

New Affiliate

New Company

New Contact

Triggers when you add a new action for a contact (task, note, or appointment).

New Contact Action

Triggers when a tag gets added to a contact.

Tag Added to Contact

Triggers when a credit card charge is processed from Infusionsoft through a merchant account.

Credit Card Charge

Triggers when you add a new expense for an opportunity or leadsource.

New Expense

New Invoice

New Opportunity

Triggers when you add a new invoice (with line item support).

Triggers when you add a new payment of any type (Cash, Refund, check, PayPal, etc.).

New Payment

New Product

Triggers when a contact subscribes to plan.

New Subscription

Triggers when a contact unsubscribes from plan.

Cancelled Subscription

Triggers when you add a new subscription plan.

New Subscription Plan

New Tag

Find a Contact by their Email Address or Username.

Find a Contact

Find an Invoice by specifying a Contact and Invoice details.

Find an Invoice

Find or Create Contact

Create Company

Creates a new contact. Can be used to update existing contacts too.

Create/Update Contact

Tag Existing Contact

Create and send a new email to a contact or multiple contacts, as well as record the email in the contacts' email history.

Send Email

Create Note

Create Order

Create Product

Update Contact

PostgreSQL is a powerful, open-source database engine with a uniquely advanced query optimizer and dozens of built in features, making it an easy choice for production databases.

New Column

New Row

Triggers when new rows are returned from a custom query that you provide. **Advanced Users Only**.

New Row (Custom Query)

New Table

Triggers when a new row is added or modified.

New or Updated Row

Finds a row in a table via a lookup column.

Find Row

Finds multiple rows in a table via a custom query you control.

Find Multiple Rows via Custom Query

Finds a row in a table via a custom query you control.

Find Row via Custom Query

Update Row

Add new Keap Max Classic contacts as new rows on PostgreSQL 

Looking for an easy way to archive those key contacts on your database? How about tagging them on your CRM? This automation will handle the whole process for you. It will trigger with each new contact you tag on Keap Max Classic, automatically adding a new row to PostgreSQL with their information and keeping your table accurate.

Add new tagged Keap Max Classic contacts to new PostgreSQL rows 

None likes to do paperwork, but you don't need to hire someone just to keep your digital records in order. This Zap, once active, will capture every new invoice you create on Keap Max Classic, storing it as a new row on any PostgreSQL table you need your accounting to access.

Add new Keap Max Classic invoices as rows to a PostgreSQL table  

If all those new Typeform entries are getting added to PostgreSQL anyway, why not automate the connection with this Zap? Once you've turned it on, this integration will trigger for every new form entry you receive on Typeform, adding the data to PostgreSQL automatically in the form of a new row, so you can pick up your workflow from there—or use another Zap after that to listen for those PostgreSQL rows and move them on to the next step in the pipeline.

Typeform helps you ask awesomely online! If you ever need to run a survey, questionnaire, form, contest etc. Typeform will help you achieve it beautifully across all devices, every time, using its next generation platform.

Typeform

New Entry

Retrieves ALL file(s) of a given form that are uploaded as part of form submission.

Retrieve ALL Files

Lookup Responses

Create an Empty Form

Duplicates an Existing Form

Update Dropdown, Multiple Choice or Ranking Question Options

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

Add new rows to PostgreSQL for new Typeform entries

Keep track of all of your form data and put it to work in your own apps with this integration, which automatically copies each Typeform entry into your MySQL database.

MySQL is a premier database used in millions of production environments around the world. Easily plug your MySQL database into any web service.

MySQL

Save Typeform form entries to a MySQL Database

Keep track of all of your Wufoo form entires and put them to work in your own apps automatically by having Zapier copy each entry into your MySQL database.

Wufoo is an easy way to create and manage HTML forms.

Wufoo

Triggers when someone fills out your form. This is a slow version wherein we check periodically for new entries.

New Entry (poll)

Triggers when a new field is added to a form.

New Field

New Form

Triggers when someone fills out your form instantly using webhooks (but you will need to create the webhooks manually).

Triggers when someone fills out your form.

New Subscription Entry

Find a form submission by a field and its value.

Find a Submission

Creates a new entry in Wufoo for a form and data you select (except not files).

Create Entry (Legacy)

Creates a new entry in Wufoo for a form and data you select.

Create Entry

Save Wufoo form entries to a MySQL database

You can use Wufoo as a front end to your SQL Server database. Wufoo is a fast and convenient way to create data capture forms and embed them in websites and web pages. Use Zapier to automatically add these Wufoo form submissions to your SQL Server database. 

SQL server (or MS SQL) is a top of the line database geared for the cloud

SQL Server

Add new Wufoo form submissions to a SQL Server database

Form responses potentially have a lot of valuable data, why not store that in a deeper database? This integration helps by automatically creating SQL Server rows with data from new responses in a Google Form. With your tools connected your responses will be sent to your own database and stored how you like.

Google Forms is an easy way to collect data from the web with a simple UI and powerful editor. Works hand-in-hand with Google Sheets!

Google Forms

Triggers when a new form response is received.

New Form Response

Triggers when a form response is added or modified.

New or Updated Form Response

Create SQL Server rows from new Google Forms responses

Form submissions contain a wealth of information, so why not control where that data lives? By connecting your forms to your databases with this integration, you can store that valuable data easily. As soon as a new response is received in your Google Forms account, you'll automatically generate a MySQL row for those details.

Create MySQL rows from new Google Forms responses

Automatically backup your spreadsheet entries to a MySQL database, so you can use the data in your own apps and more. All it takes is Google Sheets, your MySQL database, and this integration. Every new row you add to your sheet will trigger the integration, automatically creating a new row on your MySQL database.

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Google Sheets

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

New Spreadsheet Row (Team Drive)

Triggers when a new row is added to the bottom of a spreadsheet.

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.

New or Updated Spreadsheet Row (Team Drive)

Triggers when a new row is added or modified in a spreadsheet.

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

New Worksheet

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Lookup Spreadsheet Row

Finds or creates a specific find worksheet.

Find or Create Worksheet

Find or Create Row

Create a new column in a specific spreadsheet.

Create Spreadsheet Column

Create a new row in a specific spreadsheet.

Create Spreadsheet Row

Create one or more new rows in a specific spreadsheet (with line item support).

Create Multiple Spreadsheet Rows

Creates a new worksheet by copying an existing worksheet.

Copy Worksheet

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Create Spreadsheet

Creates a new worksheet in a Google Sheet.

Create Worksheet

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Clear Spreadsheet Row(s)

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row

Update one or more rows in a specific spreadsheet (with line item support).

Update Spreadsheet Row(s)

Add new Google Sheets rows to MySQL

Data gathering is important but requires manual work - automate it and save time. Zapier can automatically add new data into a SQL Server database as you capture the data in a new row in a Google Sheet. It's never been easier to aggregate all of your data in one place. 

Add new Google Sheets spreadsheet rows to a SQL Server database

If your contact information is accessed routinely by your apps, you'll want a centralized database for them. You can have that set up and maintained automatically if you spent just a few moments configuring this Zap. It will then trigger whenever you add a new contact on Salesforce, making sure to add them as a new row to a PostgreSQL table as well so every personal detail can be accessed as needed.

Salesforce is a leading enterprise customer relationship manager (CRM) application.

Salesforce

Triggers when a new Attachment is added to a case.

New Case Attachment

Triggers when a field is updated on the object specified. It will output the old and new field values.

New Field History Tracking Event

Triggers when an attachment, note, or content document is added or updated on any record of the specified Salesforce object.

New or Updated File on Record

New Lead

Triggers when a new outbound message is received in Salesforce.

New Outbound Message

Triggers when a record of the specified Salesforce object (ie. Contact, Lead, Opportunity, etc.) is created.

New Record

Triggers when a field of your choosing (ie. email address, status) is updated on any record of a specified Salesforce object (ie. Contact, Lead, Opportunity, etc.).

Updated Field on Record

Triggers when any record of the specified Salesforce object (ie. Contact, Lead, Opportunity, etc.) is updated.

Updated Record

Finds Child Records for a given Parent ID, and returns the Child records as line-items.

Find Child Records

Finds a record of a specified Salesforce object by up to two fields and values you choose.

Find Record

Finds a record of a specified Salesforce object by a field and value you choose (with line-item support).

Find Record(s)

Finds one or more records of a Salesforce object using a Salesforce Object Query (SOQL) WHERE clause (with line item support).

How a Content Company Uses Zapier to Learn From Their Email Marketing Data

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.