ExploreEducationHow do I build?MembersToolsWorkshopsJobs

Join Makerpad today

Makerpad is home to over 10 thousand folks learning to automate business workflows and build projects without code. Access PRO content, join the community & get expert support.
Learn how to build without code today
You're in 😍- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.
Get up to $200 by referring a friend

Bring no-code skills to your work

From learning new skills for your projects to automating and shipping faster in your team
For BusinessFor individuals

Share

Tutorials
/
❓ Customer Support Flow with Zapier and Airtable
Added to your list!
Oops! Something went wrong while submitting the form.
Marked as complete!
Oops! Something went wrong while submitting the form.
Mark as completeSave to watch later

❓ Customer Support Flow with Zapier and Airtable

Link to Demo

In this tutorial, you will learn how to setup a customer support flow for a multi-person support team.

What you'll need

  • Airtable
  • Zapier
  • Gmail

Estimated time to complete

  • 45 mins

You must be a member to view the full lesson

Join Makerpad today

Makerpad is home to over 10 thousand folks learning to automate business workflows and build projects without code. Access PRO content, join the community & get expert support.
Learn how to build without code today
You're in 😍- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.
Get up to $200 by referring a friend

In Airtable, create a new base and table. The first table will be called 'Support Tickets.' Create two more tables: Makerpad Support Team & Issues, respectively. Create the following columns:

  • Ticket Number (autonumber)
  • From Name (single line text)
  • From Email Address (email)
  • Subject (single line text)
  • Message (long text)
  • Submitted on (created on)
  • Category (single select: Bug Report, Tutorial Support, Feature Request, Membership)
  • Status (single select: Open, Engaged, Completed)
  • Priority (single select: Low, Normal, High, Critical)
  • Makerpad Support Team (Link to Makerpad support team)
  • Notes (long text)
  • Attachments (attachment)
  • Issues (link to Issues)

In the second table insert team member names in the first column. In the third table (Issues) add:

  • Priority (single select)
  • Status (single select)
  • Category (single select)

Add a Form view from the Support Tickets view called Contact Us.

Add Name, Email, Category, Subject, and Message.

Embed the form on your site by clicking 'Share form' and selecting '< > embed this form on your site.' (Copy the embed code and paste it on your site).

Create one more view (Gallery) under the Support Tickets table. Click 'Customize Cards' to edit how support tickets appear.

Log into Zapier and create a zap between Airtable and Email by Zapier. The trigger event in Airtable will be 'New Record in View.'

The action event for Email by Zapier will be 'Send Outbound Email.'

To should be mapped to whatever email address you are receiving support inquiries.

Subject should be linked to the Subject column in your Airtable. You can modify the Body to your preferences but in this case we have included From Name, Message, Category, and Ticket Number. From Name should be linked to the Airtable From Name column. Reply To should be linked to the From Email Address column. You're now ready to turn your zap on.

I hope you enjoy this tutorial preview, if you have any questions please reach out on Twitter @amiedelisa or @makerpad.

For access to this full tutorial please head over to https://www.makerpad.co

If you'd like this template, message @bentossell on Slack with your email for the account to send this template.

Tools

Tutorials

Stories

Ready to get started?

Join the community and start turning your ideas into solutions