Table of Contents
Collecting customer feedback is essential for improving products and services. Automating this process can save time and ensure you never miss valuable insights. In this tutorial, you'll learn how to automate customer feedback collection using IFTTT and Airtable.
Prerequisites
- An active Airtable account with a base set up for feedback collection
- An IFTTT account
- A method for customers to submit feedback (e.g., Google Forms, Typeform, or direct email)
- Basic understanding of IFTTT applets and Airtable
Step 1: Prepare Your Airtable Base
Create a new base or use an existing one dedicated to customer feedback. Ensure it has fields such as Name, Email, Feedback, Date, and any other relevant information.
Step 2: Set Up Your Feedback Submission Method
Choose a method for customers to submit feedback. For example, create a Google Form linked to a Google Sheet, or use a Typeform. Make sure the responses are collected in a centralized spreadsheet.
Example: Using Google Forms
Create a Google Form with questions like Name, Email, and Feedback. Link it to a Google Sheet to store responses.
Step 3: Connect Google Sheets to IFTTT
Log in to your IFTTT account. Create a new applet by clicking "Create". Set the trigger as "New row added" in Google Sheets.
Configure the Trigger
Select your Google account, then choose the specific spreadsheet and worksheet where feedback responses are stored.
Step 4: Connect IFTTT to Airtable
For the action, select Airtable. If Airtable is not connected, authorize IFTTT to access your Airtable account.
Configure the Action
Choose "Create record" in Airtable. Select your base and table. Map the fields from Google Sheets (Name, Email, Feedback) to Airtable fields.
Step 5: Test Your Automation
Submit a test feedback response via your Google Form. Check Airtable to see if a new record has been created with the correct data.
Additional Tips
- Use filters in IFTTT to process only certain feedback types.
- Set up email notifications for new feedback in Airtable or via IFTTT.
- Regularly review your Airtable base to analyze feedback trends.
Conclusion
By integrating Google Forms, IFTTT, and Airtable, you can automate the collection and organization of customer feedback. This setup ensures timely insights and helps you focus on improving your offerings based on real customer input.