SheetMagicSheetMagic

Guides for work at row scale.

How to run AI and web scraping from a Google Sheet: which formula does which job, what a run costs, and the workflows people actually build. Product updates land here too.

Articles
48
Series
5
Series articles
3

All articles

Find B2B Leads by Job Title in Google Sheets: 100 in One Formula

Build a prospect list of decision makers with work email, mobile, LinkedIn and company size using one =FINDLEADS() formula in Google Sheets. 100 leads cost 881 scraping credits instead of 5 hours of copying.

Newest

· 6 min read

Showing 10 of 48 articles

Latest in the series

Five series, from first formula to full workflow.

  • AI in Google Sheets

    Everything about using AI inside Google Sheets, from built-in Gemini to custom formulas to bulk automation.

    3 of 11 published

  • Web Scraping & Data Extraction

    No-code web scraping from a spreadsheet. Pull data from any website, SERP, or API directly into your cells.

    11 planned, none published yet

  • SEO Workflows

    SEO automation with Google Sheets. Keyword research, rank tracking, content audits, and competitor analysis at scale.

    10 planned, none published yet

  • Sales & Lead Generation

    Turn Sheets into a sales machine. Prospect enrichment, email outreach, CRM sync, and pipeline automation.

    8 planned, none published yet

  • Data Analysis & Reporting

    AI-powered data analysis beyond formulas. Summarize, classify, extract insights, and build reports with natural language.

    9 planned, none published yet