# Make Google Sheets Modules: Add a Row vs Search Rows > Which Make Google Sheets module to use: Add a Row, Search Rows, Update a Row or Watch New Rows, how to pick the sheet and how headers map. Source: https://learn.ynteractive.com/content/blog/make-google-sheets-modules · Updated 2026-10-20 · Free from Stepthrough (https://learn.ynteractive.com) Quick answer Make has one Google Sheets app with several modules: **Add a Row** writes a new row, **Search Rows** reads the rows that match a filter, **Update a Row** changes one row by its number, and **Watch New Rows** starts a scenario when a row is added. Most office scenarios need Add a Row (to log something) or Search Rows (to report on it). The free [first Make scenario lesson](https://learn.ynteractive.com/content/make-com-google-forms-to-google-sheets) uses Add a Row; the [daily summary lesson](https://learn.ynteractive.com/content/make-com-daily-summary-email-google-sheets-schedule) uses Search Rows. Last updated October 20, 2026 [Take the free module →](https://learn.ynteractive.com/courses/ai-for-medical-dental-admin/9)Module 9 of the free [AI for Medical & Dental Office Admin](https://learn.ynteractive.com/courses/ai-for-medical-dental-admin) course, about 12 minutes. No account needed. By [Robert Breen](https://learn.ynteractive.com/content/about) · Published October 20, 2026 · Updated October 20, 2026 · 4 min read Make · Google Sheets · Cheat sheet ## Which Google Sheets module should I use? Pick by what the step does to the sheet. | Module | Does | Use it for | | --- | --- | --- | | Add a Row | Appends one row per bundle | Logging form responses, leads, [invoices](https://learn.ynteractive.com/content/glossary/invoice) | | Search Rows | Returns every row that matches a filter | Today's requests, open tasks, overdue items | | Update a Row | Changes a row by its row number | Marking a request done after a Search Rows | | Watch New Rows | Trigger: fires on new rows | Starting a scenario when someone adds a row by hand | | Get a Cell / Update a Cell | Reads or writes one cell | A counter or a status cell | | Clear a Row / Delete a Row | Empties or removes a row | Clean-up, use with care | ## How do I set up Add a Row? Choose the spreadsheet and tab, then map one value into each column. In the lesson, Brookside Dental's form responses go to the **New patient requests** sheet: 1. Click the small **+** on the right of the Google Forms module, type **google sheets** and click **Add a Row**. 2. The Google connection is already filled in. Under **Spreadsheet ID**, click **Click here to choose file** and pick **New patient requests**. 3. Open **Sheet Name** and pick **Sheet1**. 4. Click each column field, such as **Name (A)**, and in the mapping panel click the matching form answer's **Value**. 5. Click **Save**. The [webhooks](https://learn.ynteractive.com/content/glossary/webhook) lesson does the same with a website form. Its form has no phone field, so **Phone (C)** stays empty, which is fine: an empty mapping writes an empty cell. ## Why does Make show "Name (A)" instead of "A"? Make reads row 1 as column names when **Table contains headers** is **Yes**. Keep a [header row](https://learn.ynteractive.com/content/glossary/header-row) in your sheet and every column field is labelled with its name and letter, which makes mapping much harder to get wrong. The [header row](https://learn.ynteractive.com/content/glossary/header-row) glossary entry explains why automation tools rely on it. ## How do I set up Search Rows? Pick the sheet, keep **Table contains headers: Yes**, then add a filter. The daily summary lesson filters on **Date (E)** with **Text operators: Equal to** and the value `{{formatDate(now; "YYYY-MM-DD")}}`, and leaves **Limit** empty so it returns every match. Each matching row becomes one bundle, which a Text aggregator then joins into one email. ## Try it free, step by step **Your First Make.com Scenario: Google Forms to Google Sheets**. Build your first Make.com scenario: every new Google Forms response becomes a new row in Google Sheets. Trigger, connection, mapping, Run once and a schedule. You do every step yourself in a practice copy of Make, it checks your work as you go, and “Do it for me” finishes any step you get stuck on. Free, and nothing touches your real accounts. [Start the free lesson](https://learn.ynteractive.com/modules/make-first-scenario) [Or read the full step-by-step guide](https://learn.ynteractive.com/content/make-com-google-forms-to-google-sheets) ## What goes wrong most often? - **The sheet isn't in the list.** The connection belongs to a different Google account. Create a connection with the account that owns the file. - **Columns are shifted.** Someone inserted a column after the module was set up. Reopen the module so it reloads the headers, then re-map. - **Rows land below a blank gap.** Add a Row appends after the last row with data in the table; stray content far below your data moves the insert point. Clear it. - **Search Rows finds nothing.** Compare the filter value with the real cell. Dates stored as real dates and dates stored as text do not compare the same way. [Make Scenario Errors](https://learn.ynteractive.com/content/blog/make-scenario-errors) lists the error messages that go with these. ## Key takeaways - Add a Row logs, Search Rows reports, Update a Row changes a row you found first. - Keep a header row and Table contains headers: Yes, so columns show their names. - Always pick the spreadsheet and tab from the list rather than typing IDs. - A missing sheet is almost always a connection for the wrong Google account. ## Frequently asked questions **How do I add a row to Google Sheets with Make?** Add the Google Sheets module Add a Row, choose the spreadsheet and sheet, map a value into each column and save. Every bundle that reaches it becomes a new row. **Can Make update an existing row?** Yes, with Update a Row, but it needs the row number. Get it first with Search Rows, which returns each row's number. **Does Make need a header row in Google Sheets?** It works without one, but with Table contains headers set to Yes, Make labels each column by its header, which makes mapping clearer. **Where can I practice this?** In the free [Make & Zapier Jump Start](https://learn.ynteractive.com/courses/make-zapier-jump-start) course, which uses a practice copy of Make and Google Sheets. ## Free lessons in this post - [Your First Make.com Scenario: Google Forms to Google Sheets](https://learn.ynteractive.com/content/make-com-google-forms-to-google-sheets): Build your first Make.com scenario: every new Google Forms response becomes a new row in Google Sheets. Trigger, connection, mapping, Run once and a schedule. - [On a Schedule: A Daily Summary Email from a Google Sheet in Make.com](https://learn.ynteractive.com/content/make-com-daily-summary-email-google-sheets-schedule): Build a Make scenario that runs every day at 5 PM, finds today's rows in Google Sheets, combines them with a Text aggregator and emails one summary with Gmail. - [Webhooks: Connect a Website Form to Make.com](https://learn.ynteractive.com/content/make-com-webhook-website-form-google-sheets): Start a Make scenario with a Custom webhook, paste its URL into your website form's webhook setting, send a test so Make learns the fields, and save every request to… ## Related terms Plain-English definitions, each with an example from a free lesson. [Invoice](https://learn.ynteractive.com/content/glossary/invoice) · [Webhook](https://learn.ynteractive.com/content/glossary/webhook) · [Header row](https://learn.ynteractive.com/content/glossary/header-row) · [Aggregator (Make)](https://learn.ynteractive.com/content/glossary/make-aggregator) · [Bundle (Make)](https://learn.ynteractive.com/content/glossary/make-bundle) · [Credits (Make)](https://learn.ynteractive.com/content/glossary/make-credits) · [Instant trigger](https://learn.ynteractive.com/content/glossary/instant-trigger) · [Iterator (Make)](https://learn.ynteractive.com/content/glossary/make-iterator) [The full AI glossary](https://learn.ynteractive.com/content/glossary) ## Related prompts - [End of day report prompt](https://learn.ynteractive.com/content/prompts/end-of-day-report-prompt): A ChatGPT prompt for an end of day report: paste your rough notes and get a short EOD report with what got done, what is still… [All free prompt templates](https://learn.ynteractive.com/content/prompts) ## Keep reading - [tawk.to + Make: Track New Support Tickets in a Sheet](https://learn.ynteractive.com/content/blog/tawk-to-make-new-tickets-to-google-sheets): Connect tawk.to to Make with a webhook so every new ticket becomes a row in Google Sheets with an owner and a status. A how-to guide based on the docs. - [Make Custom Webhook: Set Up, Test and Map a Form](https://learn.ynteractive.com/content/blog/make-custom-webhook-setup): Set up a Make Custom webhook: create and name it, paste the URL into a website form, let Make detect the fields, then map them to Google Sheets. - [Make Scenario Errors: Fix the 8 You'll Meet First](https://learn.ynteractive.com/content/blog/make-scenario-errors): Common Make scenario errors and fixes: ConnectionError, InvalidAccessTokenError, DataError, BundleValidationError, RateLimitError and a bad Form ID. [All blog posts](https://learn.ynteractive.com/content/blog) · [All free tutorials](https://learn.ynteractive.com/content)