On New Row Google Sheet
On New Row Google Sheet is a bot trigger that activates whenever a new row is added in a connected Google Sheet.
This means that if new customer details are entered into the sheet, DoubleTick can automatically detect the new entry and start a bot journey based on it.
This trigger is commonly used when businesses store leads or registrations in spreadsheets and want WhatsApp automation to begin as soon as new data is added.
Where to Use This Trigger
Use this trigger when:
Leads are collected in Google Sheets instead of a CRM
Customer details are being added through forms, registrations, or manual entries
You want automatic WhatsApp outreach whenever a new row is created
You want to run automation for bulk lead follow-ups
This is especially useful for webinar signups, event registrations, offline lead entry, or spreadsheet-based sales workflows.
How to Use It in Bot Studio
Step 1: Select the Trigger in Bot Studio
Open Bot Studio in your DoubleTick dashboard
Create a new journey
Select the trigger: On New Row Google Sheet
Step 2: Sign In with Google
After selecting the trigger, you will see an option to connect your Google account.
Click Sign in with Google
Log in using the same Google account where your sheet is stored
Allow the required permissions so DoubleTick can access your spreadsheet files
Once connected, DoubleTick will be able to display your available Google Sheets.
Step 3: Choose the Spreadsheet
Open the spreadsheet dropdown
Select the Google Sheet you want to connect
All sheets available in your connected Google account will appear in this list.
Step 4: Enable “Use First Row as Header”
If your sheet has column names in the first row (for example: Name, Phone Number, City), enable the checkbox:
Use First Row as Header
This helps DoubleTick correctly identify each column.
Step 5: Map the Customer Phone Number Field
To ensure the bot sends messages to the correct customer:
Open the Phone Number Field dropdown
Select the column header that contains customer phone numbers
This step is mandatory, because DoubleTick needs to know which column represents the WhatsApp number.
Step 6: Build the Journey and Publish
Once the sheet is connected, you can design your automation flow.
For example:
Connect the trigger to a Send Template action
Select the message you want to send
After publishing, whenever a new row is added in the sheet, the bot journey will run automatically.
Key Capabilities
Automatically triggers automation when new spreadsheet entries are added
Supports Google account and sheet-level selection
Allows mapping of phone number fields for correct outreach
Useful for spreadsheet-driven lead follow-up workflows
Works well for teams that manage leads outside a CRM
Example Use Case
A business collects webinar registrations in a Google Sheet.
Whenever a new row is added with a customer’s phone number, DoubleTick automatically triggers a journey and sends a confirmation template such as:
“Thank you for registering. We will share the webinar details shortly.”
This ensures instant WhatsApp follow-up without manual effort.
Last updated