SheetMagic

People who work in Google Sheets, including SEOs, marketers, sales teams and data analysts, often need to pull data from sites like Amazon, LinkedIn, YouTube, eBay, Zillow and Google search results, or generate large volumes of text and images, but doing this manually or by building custom scrapers and AI integrations is slow and technical. Today they copy-paste data by hand, write one-off scripts, or pay for separate scraping tools and AI subscriptions outside their spreadsheet. Generating unique content for hundreds or thousands of rows, like product descriptions or images, means either manual work row by row or complex API setups. This costs them hours of manual work per week and forces context-switching between tools instead of staying in the spreadsheet where the data lives.

SheetMagic is a Google Sheets extension that adds custom formulas for AI generation and web scraping, usable the same way as built-in functions like =SUM(). Formulas such as =AITEXT(), =AIIMAGE(), =VISIT(), =SERP(), =AMAZONSEARCH(), =LINKEDINCOMPANY(), =GMAPSREVIEWS(), =YTTRANSCRIPT(), =AITRANSLATE() and =VALIDATEEMAIL() let users scrape over 20 sites (YouTube, Instagram, TikTok, Amazon, eBay, Zillow, Airbnb, Indeed, and more) and generate or process content with models from OpenAI, Anthropic, Google, Meta, Mistral and OpenRouter, all referencing cell values so a single formula can run across thousands of rows. A conversational AI Chat Agent sidebar, included on paid plans, can read a sheet and take actions like writing cells, formatting, building charts, or scraping data based on a plain-English request. The product also supports image analysis of screenshots, text-to-speech, and video generation via Sora 2 and Veo 3.1, and offers a bring-your-own-key option to pay AI providers directly.