Integration with Google Form - App Script

Google Form Integration Tutorial

This guide explains how to integrate Google Forms with ABC Sales AI, allowing you to capture form submissions and automate follow-ups.

1. Setting Up Your Google Form

1. Name Your Form: Give your Google Form a clear, descriptive name.

1. Collect Essential Information:

- Name: Always include and make required

- Email: Add an Email field

- Phone: Include with country code instruction (e.g., "+60" for Malaysia)

1. Add Custom Questions: Include relevant questions like "Education level" or "Interested subject".

1. Connect to Google Sheet:

- Go to the "Responses" tab

- Click the Google Sheets icon to link responses

2. Integrating via Google Sheet

1. Access App Script: In your Google Sheet, go to Extensions → App Script.

1. Copy the Integration Script:

- In ABC Sales AI, go to Integration

- Find Google Sheet integration section

- Copy the provided script

1. Paste and Modify:

- Update \sheetName\ to your sheet's tab name (e.g., "Form Responses 1")

- Add a tag to identify leads (e.g., "Google Form")

- Link your automation's Slot ID

- Map column names exactly to your sheet headers

1. Save the Script

3. Setting Up Triggers for Automation

Add "On edit" Trigger:

1. Click Triggers (clock icon) in App Script
2. Click Add Trigger
3. Select your function (e.g., \pushAllRows\)
4. Set event type to On edit
5. Click Save and authorize

Add "On form submit" Trigger:

1. Click Add Trigger again
2. Select your function
3. Set event type to On form submit ← Critical for Google Forms!
4. Click Save and authorize

4. Testing the Integration

1. Publish and Share your Google Form
2. Submit a Test Entry (use incognito window)
3. Verify in ABC Sales AI:

- Check your automation

- Confirm contact appears with correct tags

- Verify source shows "Google Form"

- Ensure follow-up messages are triggered