Important Notice:GoogleSolution.com is an independent technology information and solutions website. It is not affiliated with Google LLC or Alphabet Inc.
Tested, copy-paste JavaScript snippets for Google Workspace automation. Connect Gmail, Google Sheets, Drive, Forms, and external APIs with zero third-party dependencies.
Scans unread customer inquiries in Gmail labeled "Leads", extracts the sender, timestamp, subject, and message body snippet, and appends them to a Google Sheet before marking the thread read.
Monitors incoming emails matching a search query (such as invoices or vendor receipts), downloads attachments (PDF, PNG, JPG), and saves them into an organized Google Drive folder.
Listens for Google Form submissions, extracts respondent name, email, and requested service, and dispatches a personalized HTML confirmation receipt immediately.
When a task or lead status is marked "Done" or "Closed", this script cuts the entire row from the active working tab and appends it to an "Archive" tab.
Reads rows of client data from Google Sheets, duplicates a Google Doc template, replaces merge tags like {{ClientName}} and {{Fee}}, and outputs ready-to-sign documents.
Reads upcoming deadlines, project milestones, or meetings from Google Sheets and automatically provisions Google Calendar events with guests and reminders.
Sends real-time formatted notifications into Slack or Google Chat spaces whenever critical spreadsheet records (e.g. VIP lead, budget threshold) are updated.
Loops through hundreds of URLs listed in Column A, performs lightweight HEAD/GET HTTP requests, and writes HTTP status codes (200, 301, 404, 500) into Column B.
Scans thousands of spreadsheet rows, identifies duplicate values in a designated key column (e.g. Email or Order ID), and deletes duplicate rows while preserving the newest entry.
Pulls data from any public or authenticated REST API (weather, currency, stock prices, or internal microservices) and populates spreadsheet rows on a schedule.
Turns a Google Sheet into an instant, free serverless webhook endpoint that receives JSON payloads from Stripe, GitHub, or Shopify and logs records in real time.
Tracks event registrations or survey entries and automatically closes the Google Form and displays a custom "Event Sold Out" message when capacity is reached.
When a row is marked "Approved" in Column E, this script automatically creates a protected range on that row so editors cannot accidentally tamper with approved numbers.
Scans Google Drive storage, identifies massive videos, zip archives, and bloated presentations, and logs file name, owner, and size into a spreadsheet for storage cleanup.
Reads dynamic inventory, available event time slots, or staff names from Google Sheets and automatically updates dropdown choices in an active Google Form.
Monitors key performance indicators (such as server error count, bounce rate, or cash balance) and triggers an immediate high-priority alert email if safety thresholds are breached.
Scans upcoming weekly schedule, detects overlapping calendar appointments, and flags double-booked time slots in a spreadsheet table for quick resolution.
Transforms a spreadsheet table into a structured JSON array of objects (using column headers as keys) and saves the file directly to Google Drive for frontend or mobile consumption.
Iterates through customer email text or support notes in Column A, uses regular expressions to isolate 10-digit phone numbers, and writes sanitized phone records to Column B.
Sends personalized outreach emails from your Gmail account to contacts listed in a spreadsheet, injecting dynamic first names, company names, and custom proposal links.
Scans Google Drive for files shared with external public links created more than 90 days ago, and restricts sharing back to private access to uphold data security.
Executes an asynchronous SQL query on a Google Cloud BigQuery dataset, waits for query completion, and streams analytical results directly into a Google Sheet tab.