> For the complete documentation index, see [llms.txt](https://learn.doubletick.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learn.doubletick.io/bot-studio/set-up-bot-triggers/on-new-row-google-sheet.md). # 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 1. Open **Bot Studio** in your DoubleTick dashboard 2. Create a new journey 3. 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. 1. Click **Sign in with Google** 2. Log in using the same Google account where your sheet is stored 3. 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 1. Open the spreadsheet dropdown 2. 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: 1. Open the Phone Number Field dropdown 2. 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. --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://learn.doubletick.io/bot-studio/set-up-bot-triggers/on-new-row-google-sheet.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.