Google Sheets Tutorials

Organizes, analyzes, and collaborates on data in spreadsheets for productivity and data analysis.

7 tutorialsContent & Copywriting, Data Analysis, Software Engineering
How to use Gemini with Google Sheets
PUBLISHED 04/02/2025BEGINNER
Content & CopywritingData AnalysisSoftware EngineeringFinanceFundamentalsMarketingOperationsPersonal ProductivityStrategy & Management

Use the Gemini sidebar to create tables, analyze data, perform conditional formatting, and create formulas to analyze data.

Google SheetsGoogle SheetsGeminiGemini
Extract PDF receipts from email to spreadsheet using AI
PUBLISHED 04/02/2025INTERMEDIATE
AdministrativeData AnalysisSoftware EngineeringFinanceOperationsPersonal Productivity

Save hours of accounting time each month by automatically extracting invoices from your emails.

Google SheetsGoogle SheetsZapierZapierChatGPTChatGPT
Develop a comprehensive corporate research assistant
PUBLISHED 04/02/2025INTERMEDIATE
Content & CopywritingData AnalysisResearch & InnovationMarketingOperationsPersonal ProductivitySalesStrategy & Management

Design an AI-powered assistant that automates company research, regularly gathering information about your competitors.

SlackSlackGoogle SheetsGoogle SheetsLindyLindy
Design engaging data visualizations with the new Claude analysis tool
PUBLISHED 04/02/2025BEGINNER
Content & CopywritingData AnalysisSoftware EngineeringFinanceFundamentalsResearch & InnovationMarketingOperationsPersonal ProductivityStrategy & Management

Learn to use the new Claude analysis tool and take advantage of its capabilities for different tasks.

Google SheetsGoogle SheetsChatGPTChatGPTClaudeClaude
Create custom GPT functions in Google Sheets
PUBLISHED 04/02/2025ADVANCED
Content & CopywritingData AnalysisSoftware EngineeringResearch & InnovationMarketingOperationsPersonal ProductivityProject Management

Embed ChatGPT directly in Google Sheets with custom Apps Script functions — summarize, classify, translate, and analyze data without leaving the spreadsheet.

Google SheetsGoogle Sheets
Convert inbound emails into actionable leads using AI
PUBLISHED 04/02/2025INTERMEDIATE
AdministrativeData AnalysisMarketingOperationsPersonal ProductivityProject ManagementSales

Automatically extract customer details from inbound emails and add them to a leads database.

AirtableAirtableGoogle SheetsGoogle SheetsZapierZapierChatGPTChatGPT
Automate local business outreach with AI and nocode
PUBLISHED 04/02/2025ADVANCED
Content & CopywritingData AnalysisSoftware EngineeringMarketingOperationsPersonal ProductivityProject ManagementSalesSEOStrategy & Management

Learn to contact local businesses in a personalized way, at scale, thanks to AI automation.

ApifyApifyGoogle SheetsGoogle SheetsMakeMake