Warning: Modifying Google Sheet Titles or Values
Warning: Modifying the titles or values in the Google Sheet will disrupt the entire integration and require a reset. Do not make any changes to the Google Sheet titles or values. 1…
Warning: Modifying the titles or values in the Google Sheet will disrupt the entire integration and require a reset. Do not make any changes to the Google Sheet titles or values.
Set Up a Custom Message in Message Flow
-
Navigate to Automation > Message Flow > + Create New Flow.
-
For Google Form notifications, you can use any variable from your spreadsheet. Using the example google sheet above, available variables include:
{{Your Name}}and{{Your Age}}. Here's how your template might look:
Hi {{Your name}},
Thanks for your submission. Your age is {{Your Age}}.
- Click "Save" after setting up your message template.
(Visual: Screenshot of the Message Flow editor with an example message template)
Set Up ChatDaddy Notification
-
In ChatDaddy, go to Automation > Shop Notifications > + Create.
-
Select "Google Form" as the trigger.
-
Enter the spreadsheet ID you copied earlier. This is the string of characters between
d/and/editin the spreadsheet URL. -
Click "Save".
Configure Notification Settings
-
Keep "Override Recipient" disabled if you have labeled the column "WhatsApp Number (with country code)" in your spreadsheet.
-
Enter your preferred notification name in the field "Notification Nickname"
-
Choose which channel you want to send messages from in the "Channel"
-
Select the default country code in the "Default country code"
(Visual: Screenshot of the notification settings page in ChatDaddy)
Set Up a Custom Trigger for Google Form Submissions
-
Click "New trigger"
-
Expand the trigger section
-
Select the message flow you just set up
-
Click "Save".
(Visual: Screenshot of the Trigger setup page)
Enable and Test Output
-
Submit a test Google form using your own phone number to verify the setup.
-
Verify that you receive the notification.
What to do if you don't receive a notification: Check configuration settings and contact support if needed. Also, check to ensure the trigger switch is turned on.