SSheetError·1d ago#NAME? "Unknown function" in Google Sheets: fix the misspelled function nameYou 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 it3 min read·sheeterror.hashnode.dev
HHayrullah Kar·2d agoGoogle Sheets to Custom App: Log Two Weeks of Edits Before You Ask for a QuoteCollisions 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
SShijith Pulikkal·2d agoAutomated Weekly Google Ads Week-over-Week Performance ComparisonHow two Make scenarios turn raw campaign data into a Google Sheet and a plain-English weekly summary5 min read·xtractstudio.hashnode.dev
SShijith Pulikkal·2d agoReplace 26 Make Modules with One Regex Function per FieldHow I cut a Gmail lead scenario from about 29 credits per email to 2 by parsing inside the Add a Row mapping6 min read·xtractstudio.hashnode.dev
SShijith Pulikkal·3d agoHow I Track Competitor Prices Daily with Apify, Make.com and Google SheetsA three-module, no-server pipeline that clicks through a product configurator, reads the live price and logs it to a sheet8 min read·xtractstudio.hashnode.dev
SShijith Pulikkal·3d agoHow I Built a Free Daily Price Scraper with Playwright, GitHub Actions and Google SheetsScrape 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.dev2O
SShijith Pulikkal·3d agoAutomate Rilldata Gmail CSV Reports into Google Sheets with Make.com (Incrementally)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
SShijith Pulikkal·3d agoHow to Send RB2B Visitor Data to Google Sheets Using Make.comA step-by-step guide to capturing person-level and company-level website visitors in a spreadsheet, automatically.6 min read·xtractstudio.hashnode.dev
SShijith Pulikkal·3d agoMake.com Roundel Gmail CSV to Google Sheets: Append and Update RowsImport 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
SShijith Pulikkal·3d agoI Turned a Weekly Google Ads Report Into an AI Avatar Heygen VideoHow 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 shorter10 min read·xtractstudio.hashnode.dev