Google Forms to Airtable CRM Automation + Slack Alerts (Make.com)

You set up a Google Forms intake form, shared the link, and leads started coming in. Now what? Every response sits inside Google Forms' response tab — a place nobody on your team checks regularly. By the time someone exports the data, the lead has gone cold. This Google Forms to Airtable automation fixes the gap: every form submission automatically creates a structured CRM record in Airtable and pings your team on Slack. No exporting, no copy-pasting, no leads slipping through.

Why This Google Forms Automation + Airtable Is a Free CRM Stack

Most CRM tools cost $25-50 per user per month. For freelancers and small agencies handling 10-30 clients at a time, that's hard to justify. This Google Forms automation connects a completely free form tool to Airtable's free CRM — with Make.com's free plan running the connection. The total cost for this stack is $0 per month — and it handles everything a basic CRM needs: structured intake, status tracking, and team notifications.

CRM Stack Cost Comparison

How the Google Forms to Airtable CRM Automation Works

When someone submits your Google Forms client intake form, Make.com picks up the response and runs two actions: it creates a new record in your Airtable CRM with the client's name, email, company, service needed, budget, project description, and a default status of "New" — then sends a Slack message to your team channel with all the details formatted for quick scanning.

You can build this entire automation on Make.com's free plan — no credit card required. Start free on Make.com →

Create your free Airtable client CRM — structured fields, Kanban views, no credit card needed. Try Airtable free →

What Gets Captured Automatically

Google Forms Uses Polling — What That Means for Response Time

This is where Google Forms differs from tools like Stripe or Typeform. Stripe and Typeform support webhooks — they notify Make.com the instant something happens, using zero operations while idle. Google Forms does not support webhooks through Make.com. Instead, the scenario polls Google Forms on a schedule, checking for new responses at a set interval.

On the free plan, the minimum polling interval is 15 minutes. On the Core plan ($9/month, annual billing), you can set it as low as 1 minute. This means there's a delay between when someone submits your form and when the Airtable record and Slack notification appear.

For client intake, this delay is usually fine — nobody expects a response within seconds of filling out an inquiry form. But it matters for your Make.com operation budget because every poll costs 1 operation, whether or not there's a new response.

Polling Operation Cost on Make.com

Why Airtable Instead of Google Sheets for a Client CRM

Google Sheets works well for logging data — several tutorials on this site use it for lead tracking. But for managing client relationships, Airtable adds structure that spreadsheets lack. Airtable gives you typed fields: an Email column that validates addresses, a Date column that formats consistently, and a Status column using Single Select so your team picks from predefined options instead of typing free text. You can switch from Grid view to Kanban view to see your pipeline visually — drag clients from "New" to "Contacted" to "Qualified" without editing cells. Airtable's free plan includes 1,000 records per base and up to 5 editors — more than enough for most service businesses.

Don't Use Slack? Alternatives That Work the Same Way

This guide uses Slack for team notifications, but Make.com supports any messaging tool. If your team doesn't use Slack, swap the last module for one of these — the rest of the workflow stays identical. Gmail: send a notification email to your team instead. Microsoft Teams: same concept as Slack, select the Teams module and pick your channel. Google Chat: if you're already in Google Workspace, this is the simplest swap.

What You Need Before Starting

You'll need four things ready before opening Make.com. A Google Form for client intake — this tutorial uses six fields: Full Name, Email Address, Company Name, Service Needed (dropdown), Budget Range (dropdown), and Project Description. An Airtable account with a base called "Client CRM" containing a table called "Leads" with columns for Name, Email, Company, Service, Budget, Description, Date Added, Status, and Source. A Slack workspace with a notification channel (this guide uses #new-client). And a free Make.com account.

How to Build the Google Forms to Airtable CRM Automation

1. Create a new scenario in Make.com — click "Create a new scenario" on your dashboard. You'll see an empty canvas with a large purple + button in the center and "Every 15 minutes" in the bottom toolbar — this confirms Google Forms uses a polling trigger, not a webhook.

2. 

3. Click the + button and search for "Google Forms" — select "Watch Responses." This is a polling module that checks your form for new submissions at a set interval. Connect your Google account through OAuth, then click the "Search" button next to Form ID to browse your forms. Select your Client Intake Form.

4. 

5. After selecting the form, the Form ID field populates automatically. Leave Limit at its default value — this controls how many responses are processed per polling cycle. Click Save.

6. 

7. Make.com asks where to start processing data. Select "From now on" — this means the scenario will only pick up new submissions going forward, ignoring any existing responses. Click Save.

8. 

9. Test the trigger to get sample data — click "Run once" at the bottom of the canvas, then open your Google Form preview in another tab and submit a test response. Return to Make.com — the Google Forms module should show a green checkmark with a "1" badge. Click the output bubble to inspect the data structure.

10. 

11. 💡 Pro Tip: Google Forms returns a complex nested data structure — not flat field values like Typeform or Stripe. Each answer appears under Answers as a named collection (e.g., "Answers: Full Name", "Answers: Email Address"), and the actual text value is nested one level deeper. When mapping fields in the next steps, you need to expand each answer collection and select the text value inside it — not the collection itself. If you map the collection directly, Airtable will receive an object instead of a text string and throw a parsing error.
12. Add an Airtable module — click the + button after Google Forms, search for "Airtable" and select "Create a Record." If you haven't connected Airtable yet, click "Create a connection," select Airtable OAuth as the connection type, and authorize access to your bases.

13. 

14. Select your Base ("Client CRM") and Table ("Leads") from the dropdowns. Airtable fields appear automatically. Map the first fields from the Google Forms trigger: for Name, expand the Answers collection and select "Answers: Full Name" — Make.com will insert the correct nested path to the text value. Do the same for Email, mapping it to "Answers: Email Address."

15. 

16. Scroll down and map the remaining form fields. Company maps to "Answers: Company Name", Service to "Answers: Service Needed", Budget to "Answers: Budget Range", and Description to "Answers: Project Description." For Date Added, leave it empty or use the now function if you want the current timestamp. For Status, click the "Map" toggle to enable manual input and type "New." For Source, enable Map and type "Google Forms."

17. 

18. 💡 Pro Tip: If you see a [422] error saying "Cannot parse value for field Service" or similar, it means the value from Google Forms doesn't match Airtable's expected format. The simplest fix is to change Service and Budget columns in Airtable from Single Select to Single line text — this accepts any value without exact matching. You can convert them back to Single Select later once you've confirmed the data flows correctly, and Airtable will auto-create options from your existing values.
19. Add a Slack module — click the + button after Airtable, search for "Slack" and select "Send a Message." Connect your Slack workspace through OAuth. Set Channel type to "Public channel" and select your notification channel (e.g., #new-client). In the Text field, compose a message using mapped fields. A useful pattern: map the Name and Email from the Airtable module output (not the Google Forms module) — this confirms the data actually made it into your CRM, and gives you access to the Airtable record URL.

20. 

21. Test the full scenario — click "Run once," then submit another test response through your Google Form. All three modules should fire with green checkmarks and "1" badges.

22. 

23. Verify the results in Airtable — open your Client CRM base, Leads table. A new row should appear with all the mapped fields populated, Status set to "New," and Source set to "Google Forms."

24. 

25. 

26. Check your Slack channel — the #new-client channel should show a formatted notification with the lead's name, email, company, service, and budget.

27. 

28. Activate the scenario and set the polling schedule — click the toggle to turn the scenario on, then click the clock icon or the scheduling area to set your polling interval. The free plan minimum is 15 minutes. For optimal operation usage, consider using Advanced scheduling to restrict polling to business hours only.

29. 

30. Start building this automation on Make.com's free plan — 1,000 operations per month, enough for hundreds of new leads. Start free on Make.com →