---
title: "#google-sheets articles | Hashnode"
description: "Explore 328 articles tagged #google-sheets on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/google-sheets"
---

Tag

# #google-sheets

328 posts · 86 followers

[SheetError](https://hashnode.com/@sheeterror) · [1d ago](https://hashnode.com/posts/name-unknown-function-in-google-sheets-fix-the-misspelled-function-name/6afa8f49ec731951ec7b7206)

### [#NAME? "Unknown function" in Google Sheets: fix the misspelled function name](https://sheeterror.hashnode.dev/name-unknown-function-in-google-sheets-fix-the-misspelled-function-name?utm_source=hashnode&utm_medium=feed)

You type what looks like a normal VLOOKUP and the cell shows #NAME?. The tooltip says Unknown function: ‘VLOKUP’. The ranges are fine. The formula never ran. Sheets doesn't recognize the name. Why it

3 min read · [sheeterror.hashnode.dev](https://sheeterror.hashnode.dev/name-unknown-function-in-google-sheets-fix-the-misspelled-function-name?utm_source=hashnode&utm_medium=feed)

[Hayrullah Kar](https://hashnode.com/@magesheet) · [2d ago](https://hashnode.com/posts/google-sheets-to-custom-app-log-two-weeks-of-edits-before-you-ask-for-a-quote/6af981f77ee70ce106b40160)

### [Google Sheets to Custom App: Log Two Weeks of Edits Before You Ask for a Quote](https://magesheet-team.hashnode.dev/google-sheets-to-custom-app-log-two-weeks-of-edits-before-you-ask-for-a-quote?utm_source=hashnode&utm_medium=feed)

Collisions and accountability are the two sheet problems you can count. An installable onEdit log, an overlap finder and a report with a rule of thumb that is mine, tested with 113 tests.

18 min read · [magesheet-team.hashnode.dev](https://magesheet-team.hashnode.dev/google-sheets-to-custom-app-log-two-weeks-of-edits-before-you-ask-for-a-quote?utm_source=hashnode&utm_medium=feed)

[Shijith Pulikkal](https://hashnode.com/@shijithpulikkal) · [2d ago](https://hashnode.com/posts/automated-weekly-google-ads-week-over-week-performance-comparison/6af97ea85f4766ad53f12c86)

### [Automated Weekly Google Ads Week-over-Week Performance Comparison](https://xtractstudio.hashnode.dev/automated-weekly-google-ads-week-over-week-performance-comparison?utm_source=hashnode&utm_medium=feed)

How two Make scenarios turn raw campaign data into a Google Sheet and a plain-English weekly summary

5 min read · [xtractstudio.hashnode.dev](https://xtractstudio.hashnode.dev/automated-weekly-google-ads-week-over-week-performance-comparison?utm_source=hashnode&utm_medium=feed)

[Shijith Pulikkal](https://hashnode.com/@shijithpulikkal) · [2d ago](https://hashnode.com/posts/replace-26-make-modules-with-one-regex-function-per-field/6af96b95048535561ad92acc)

### [Replace 26 Make Modules with One Regex Function per Field](https://xtractstudio.hashnode.dev/replace-26-make-modules-with-one-regex-function-per-field?utm_source=hashnode&utm_medium=feed)

How I cut a Gmail lead scenario from about 29 credits per email to 2 by parsing inside the Add a Row mapping

6 min read · [xtractstudio.hashnode.dev](https://xtractstudio.hashnode.dev/replace-26-make-modules-with-one-regex-function-per-field?utm_source=hashnode&utm_medium=feed)

[Shijith Pulikkal](https://hashnode.com/@shijithpulikkal) · [3d ago](https://hashnode.com/posts/how-i-track-competitor-prices-daily-with-apify-make-com-and-google-sheets/6af80beead7244103bdf716f)

### [How I Track Competitor Prices Daily with Apify, Make.com and Google Sheets](https://xtractstudio.hashnode.dev/how-i-track-competitor-prices-daily-with-apify-make-com-and-google-sheets?utm_source=hashnode&utm_medium=feed)

A three-module, no-server pipeline that clicks through a product configurator, reads the live price and logs it to a sheet

8 min read · [xtractstudio.hashnode.dev](https://xtractstudio.hashnode.dev/how-i-track-competitor-prices-daily-with-apify-make-com-and-google-sheets?utm_source=hashnode&utm_medium=feed)

[Shijith Pulikkal](https://hashnode.com/@shijithpulikkal) · [3d ago](https://hashnode.com/posts/how-i-built-a-free-daily-price-scraper-with-playwright-github-actions-and-google-sheets/6af7fcf2fe28fc546e49ccb0)

### [How I Built a Free Daily Price Scraper with Playwright, GitHub Actions and Google Sheets](https://xtractstudio.hashnode.dev/how-i-built-a-free-daily-price-scraper-with-playwright-github-actions-and-google-sheets?utm_source=hashnode&utm_medium=feed)

Scrape JavaScript price configurators daily with Playwright and GitHub Actions, log to Google Sheets for free. Includes the real bugs I hit.

10 min read · [xtractstudio.hashnode.dev](https://xtractstudio.hashnode.dev/how-i-built-a-free-daily-price-scraper-with-playwright-github-actions-and-google-sheets?utm_source=hashnode&utm_medium=feed)

[2](https://hashnode.com/posts/how-i-built-a-free-daily-price-scraper-with-playwright-github-actions-and-google-sheets/6af7fcf2fe28fc546e49ccb0)

[Shijith Pulikkal](https://hashnode.com/@shijithpulikkal) · [3d ago](https://hashnode.com/posts/automate-rilldata-gmail-csv-reports-into-google-sheets-with-make-com-incrementally/6af7ed6dc465fabca0d19592)

### [Automate Rilldata Gmail CSV Reports into Google Sheets with Make.com (Incrementally)](https://xtractstudio.hashnode.dev/automate-rilldata-gmail-csv-reports-into-google-sheets-with-make-com-incrementally?utm_source=hashnode&utm_medium=feed)

A step-by-step build that pulls a scheduled CSV from Gmail, keeps only one account's rows, and adds only new or changed data to Google Sheets.

6 min read · [xtractstudio.hashnode.dev](https://xtractstudio.hashnode.dev/automate-rilldata-gmail-csv-reports-into-google-sheets-with-make-com-incrementally?utm_source=hashnode&utm_medium=feed)

[Shijith Pulikkal](https://hashnode.com/@shijithpulikkal) · [3d ago](https://hashnode.com/posts/how-to-send-rb2b-visitor-data-to-google-sheets-using-make-com/6af7de361f5a1e62e7dafcec)

### [How to Send RB2B Visitor Data to Google Sheets Using Make.com](https://xtractstudio.hashnode.dev/how-to-send-rb2b-visitor-data-to-google-sheets-using-make-com?utm_source=hashnode&utm_medium=feed)

A step-by-step guide to capturing person-level and company-level website visitors in a spreadsheet, automatically.

6 min read · [xtractstudio.hashnode.dev](https://xtractstudio.hashnode.dev/how-to-send-rb2b-visitor-data-to-google-sheets-using-make-com?utm_source=hashnode&utm_medium=feed)

[Shijith Pulikkal](https://hashnode.com/@shijithpulikkal) · [3d ago](https://hashnode.com/posts/make-com-roundel-gmail-csv-to-google-sheets-append-and-update-rows/6af7d9d3d0a884783c301c70)

### [Make.com Roundel Gmail CSV to Google Sheets: Append and Update Rows](https://xtractstudio.hashnode.dev/make-com-roundel-gmail-csv-to-google-sheets-append-and-update-rows?utm_source=hashnode&utm_medium=feed)

Import a daily Gmail CSV into Google Sheets with Make: append new rows and update only changed ones using a row signature to cut credits.

7 min read · [xtractstudio.hashnode.dev](https://xtractstudio.hashnode.dev/make-com-roundel-gmail-csv-to-google-sheets-append-and-update-rows?utm_source=hashnode&utm_medium=feed)

[Shijith Pulikkal](https://hashnode.com/@shijithpulikkal) · [3d ago](https://hashnode.com/posts/i-turned-a-weekly-google-ads-report-into-an-ai-avatar-heygen-video/6af803b30b0d2f169483da9d)

### [I Turned a Weekly Google Ads Report Into an AI Avatar Heygen Video](https://xtractstudio.hashnode.dev/i-turned-a-weekly-google-ads-report-into-an-ai-avatar-heygen-video?utm_source=hashnode&utm_medium=feed)

How Google Sheets, Apps Script, Make.com, OpenAI and HeyGen work together to post a narrated campaign update to WordPress every Monday, and how I'd make the pipeline shorter

10 min read · [xtractstudio.hashnode.dev](https://xtractstudio.hashnode.dev/i-turned-a-weekly-google-ads-report-into-an-ai-avatar-heygen-video?utm_source=hashnode&utm_medium=feed)
