...
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