APIs (with Zapier)

Easy to Use API tool - Zapier is an IFTTT (IF This Then That) application that connects one application to another and triggers a certain action after a certain criterion is met.  One team used this to insert google form entries into another non-Google database (e.g. AirTables).  Another team used Zapier to set up a Zoho payment subscription after someone entered a new record on a Knack-based signup form.  Click here for more info.

We used it to connect our Knack database with Squarespace and Mailchimp.

• Automation between different applications
• Has a free pricing tier with limited capabilities

Zapier easily connects different applications using API tools. For our situation, we connected Squarespace and Knack. Every time someone would fill out a form on the Squarespace website, Zapier would act as a bridge and automatically create a new record into the Knack database based on the responses in the form.

Example:
Goal: Make room reservations with detailed events in Google Calendar
Trigger: A new Google Form submission (pass all form inputs down the line)
Action: Check for conflicting events in a specific calendar
Action: Paths (Condition check)
Action: Condition 1 - If there is a conflicting event
Action: Condition 1 - Send rejection email (using “Zap” template + embed form inputs)
Action: Condition 2 - If there is no conflicting event
Action: Condition 2 - Send under review email (using “Zap” template + embed form inputs)
Action: Condition 2 - Create a Google doc from a template to store form submission details
Action: Condition 2 - Create a detailed calendar event including all form inputs + generated doc attached
Process Complete