Google Sheets workflow'ları
4.090 sonuç — 488 indirilebilir workflow dosyası, 3.602 kaynağa bağlı n8n referansı
Enrich contact emails and phone numbers with Tomba and Google Sheets
Quick overview This workflow runs on a schedule to read “Pending” contacts from Google Sheets, uses Tomba to find email addresses and (when available) phone numbers, then writes the enriched results back to the same spreadsheet. How it works Runs on a scheduled trigger. Reads rows from a Google Sheets worksheet where the Status column equals “Pending”. Processes the contacts in batches and sends each contact’s name, company, and domain to Tomba to find an email address. If Tomba indicates phone data is available, looks up the phone number in Tomba using the found email address. Normalizes the output (email, phone, score, and enrichment status) and updates the matching row in Google Sheets with the results and Status set to “Done”. Setup Connect your Google Sheets OAuth credentials and set the target spreadsheet and worksheet that contains your contacts. Add a Tomba API credential. Ensure your Google Sheet includes the expected columns (First Name, Last Name, Company, Domain, Status) and output columns (Email, Phone, Score), with Status set to “Pending” for rows you want to enrich.
Enrich LinkedIn profiles into full contacts with Tomba and Google Sheets
Quick overview This workflow runs on a schedule to read “Pending” LinkedIn profile URLs from Google Sheets, uses Tomba to find and enrich contact details (email and phone), and writes the results back to the same sheet with updated status and scoring. How it works Runs on a schedule trigger. Reads rows from a Google Sheets worksheet where the Status column is set to “Pending”. Processes each LinkedIn URL in batches and calls Tomba’s LinkedIn Finder to retrieve the person’s email and phone details. Normalizes the returned contact data (including combining multiple phone numbers) and sets an enrichment status based on whether an email is found. Updates the corresponding row in Google Sheets with the enriched fields (Email, Phone, Score) and marks the Status as “Done”. Setup Connect your Google Sheets OAuth2 credentials and set the target spreadsheet and worksheet that contains LinkedIn URL, Status, and output columns. Add your Tomba API credentials and ensure the LinkedIn URL column contains valid LinkedIn profile links. Make sure your sheet includes a row_number field (used for matching updates) and uses “Pending” as the Status value for rows you want to process.
Audit website SEO with Groq, Google PageSpeed and Google Sheets
Quick overview This workflow audits a submitted website URL by extracting on-page SEO signals from the HTML, pulling Google PageSpeed Insights scores, and using Groq (Llama 3.3 70B) to generate a scored SEO report, then logs the results to Google Sheets and returns the audit via webhook. How it works Receives a POST webhook request containing a JSON body with a target url to audit. Fetches the page HTML for the provided URL and stops with an error response if no HTML is returned. Extracts on-page SEO signals from the HTML (title, meta description/keywords, headings, image alt coverage, links, canonical, robots, viewport, Open Graph/Twitter tags, schema, word count, and language). Calls the Google PageSpeed Insights API for mobile to retrieve performance, accessibility, SEO, and best-practices results. Combines the extracted on-page data with the PageSpeed results and sends it to Groq via a LangChain agent to produce a strict, structured JSON audit with scores, findings, fixes, and top priorities. Parses and validates the AI JSON output, appends/updates the audit record in Google Sheets, and returns the final audit JSON to the webhook caller (or returns a 400 error if parsing fails)
Generate personalized cold email drafts from Google Sheets with Groq and Tavily
Quick overview This scheduled workflow reads leads from Google Sheets, researches each company with Tavily Search, uses Groq (Llama 3.3 70B) to generate a short personalized cold email, and saves the result as a Gmail draft while updating the lead status back in the sheet. How it works Runs on an hourly schedule trigger. Reads lead rows from Google Sheets and keeps only rows that have an email address and are not marked with status "sent". Processes leads one at a time and uses the Tavily Search API to fetch a brief company overview based on the lead’s company name. Sends the lead details plus the Tavily research summary to Groq (Llama 3.3 70B) to generate a JSON-formatted email subject, body, and personalization hook. Parses and validates the AI output to ensure a subject and body are present, and routes failures to an error log. Creates a Gmail draft with the generated subject and body, updates the corresponding row in Google Sheets with the new status and generated fields, and waits briefly before continuing to the next lead. Setup Create and connect a Google Sheets OAuth2 credential, then select the target spreadsheet and sheet in both the Google Sheets read and update steps. C
Nurture leads from Google Sheets with Gmail, SMS, and OpenRouter AI
Quick overview Automatically nurture leads with AI-personalized email follow-ups (plus optional SMS) across 3 stages triggered hourly, respecting business hours, and fully tracked in Google Sheets. How it works Runs every hour, filtered to a business-hours window (default 9am–6pm, timezone configurable). Reads all leads from Google Sheets and filters those due for follow-up skipping replies, unsubscribes, and completed leads. Routes by stage Stage 1 (Welcome), Stage 2 (Check-in), or Stage 3 (Final nudge). AI writes the email an LLM (via OpenRouter) generates a personalized subject + body using the lead's name, source, and service of interest. Sends via Gmail, and optionally an SMS via Seven/Twilio (Day 1 and Day 4, with consent and dedupe checks). Updates Google Sheets advances the lead's stage, sets the next follow-up timestamp, and marks SMS sent. Setup Import all 4 workflows they share one Google Sheet. Paste your Sheet ID/tab name into each 🔧 CONFIG node (same Sheet ID throughout). Connect Google Sheets, Gmail, and OpenRouter credentials. Edit the 3 LLM prompt nodes to replace "YOUR NAME/company" with your actual brand name. (Optional) Connect Seven/Twilio for SMS, and adjust
Route medical equipment form leads to Google Sheets and Slack
Quick overview Youtube Video: https://youtu.be/Zi872Mz4GnE?si=5yhYcMMH633Sqdd9 This workflow captures medical equipment enquiries via an n8n form, stores or updates each submission in Google Sheets, flags low-quality leads based on free email domains, and routes qualified enquiries to the right Slack channel depending on the stated purchase timeline. How it works Receives a submission from an n8n form collecting company, contact, and equipment interest details. Appends or updates the enquiry in Google Sheets, matching on the Work Email Address. Checks whether the email domain is a free provider (for example, gmail.com or outlook.com) and posts a “Low Quality Lead” alert to Slack when it is. For non-free domains, looks up the matching row in Google Sheets and continues only when a record is found. Routes qualified enquiries based on Purchase Timeline, sending “Immediate Need” submissions to a dedicated Slack channel and “Budgeting for Next Fiscal Year” submissions to a follow-up campaign Slack channel. Setup Set up the n8n Form Trigger and publish the form so users can submit enquiries. Add a Google Sheets Service Account credential, share the target spreadsheet with the service acc
Run a hotel WhatsApp concierge using Google Gemini and Google Sheets
Quick overview Youtube Video: https://youtu.be/q2vPN9eub1o?si=lSo4c0kQMNQd_Aad This workflow acts as a WhatsApp hotel concierge that looks up guest profiles, reservations, and open service requests in Google Sheets, consults a Google Docs amenities guide, and uses Google Gemini with Redis memory to reply and optionally create or update reservations and service requests. How it works Triggers when a WhatsApp message is received and continues only if the incoming message contains text. Looks up the guest by WhatsApp number in a Google Sheets “Guest Details” spreadsheet and checks whether Do Not Disturb (DND) is enabled. If the guest is not in DND, fetches the guest’s reservations and any incomplete service requests from Google Sheets. Determines whether the guest is new, currently checked in (based on today’s date between check-in and check-out), and whether any requests are pending, then packages this context for the assistant. Uses Google Gemini with Redis chat memory to generate a WhatsApp-ready reply, calling a Google Docs amenities document when answering policy/pricing/amenity questions. When appropriate, the assistant writes back to Google Sheets to create or update guest prof
Send multi-carrier shipping quotes via WhatsApp with Gemini and ShipEngine
Quick overview Youtube Video: https://youtu.be/jIGBUW_1Sx0?si=BNXzk95soO0Nefan This workflow responds to incoming WhatsApp messages, validates the sender in HighLevel, uses Google Gemini with Redis memory to collect shipment details, fetches multi-carrier rates from ShipEngine, applies a commission markup, logs the quote to Google Sheets, and sends the best options back via WhatsApp. How it works Triggers when a new WhatsApp message is received. Looks up the sender’s phone number in HighLevel and stops outreach if the contact is marked Do Not Disturb. Uses a Google Gemini-powered agent with Redis chat memory to collect and confirm shipment details, creating the contact in HighLevel if needed or marking them DND if they opt out. If shipment data collection is complete, requests shipping rates from the ShipEngine Rates API for the configured carriers. Calculates a commission markup, filters for valid rates, and selects the cheapest and fastest options to format a quote message. Appends the quote text and metadata to a Google Sheets spreadsheet and sends the quote back to the customer via WhatsApp. Setup Connect WhatsApp Business credentials for both the WhatsApp trigger and send acti
Handle portfolio contact form submissions with webhook, SMTP and Google Sheets
Quick Overview This workflow receives portfolio contact form submissions via a webhook, validates and normalizes the input, then logs the message to Google Sheets and sends a confirmation email via SMTP before returning a JSON success or error response. How it works Receives a POST request on a webhook endpoint for contact form submissions. Validates that name, email, and message are present and within length/format limits, and returns a 400 JSON error response for invalid requests. Normalizes the fields (trim text, lowercase email, set defaults, add timestamp and source) for valid submissions. Appends the submission details to a Google Sheets spreadsheet. Sends a personalized HTML confirmation email to the submitter using SMTP. Returns a 200 JSON success response with basic submission details and CORS headers. Setup Configure the webhook URL in your portfolio contact form and restrict allowed origins/CORS to your domain. Add a Google Sheets OAuth2 credential and set the target spreadsheet and sheet where submissions should be appended. Ensure the Google Sheet has columns that match the fields being written (Name, Email, Subject, Message, Phone, Timestamp, Source). Add an SMTP cred
Audit Google Drive backup freshness with Google Sheets and Slack
Quick overview This workflow runs nightly to audit a Google Drive backup folder against an SLA table in Google Sheets, logging a per-source scorecard and sending a Slack alert only when backups are missing, stale, or unexpectedly small. How it works Runs on a nightly schedule. Reads an SLA table from Google Sheets that defines expected backup sources, filename patterns, cadence, and freshness/size thresholds. Searches a specified Google Drive folder and retrieves metadata for all non-trashed files. Compares each SLA row to matching Drive files to classify the newest backup as OK, MISSING, STALE, or SHRUNK and builds an alert summary for any failures. Appends one scorecard row per source to a Google Sheets audit tab with the run time, verdict, newest file details, and size comparisons. Posts a single Slack message listing all failing sources when at least one source is not OK. Setup Add Google Sheets OAuth2 credentials, select the spreadsheet and the SLA and scorecard sheet tabs in the Google Sheets nodes. Add Google Drive OAuth2 credentials and replace the placeholder folder ID in the Drive search query to point at your backup folder. Add Slack credentials and choose the channel to
Generate English–Polish vocabulary quizzes with Google Sheets and Groq
Quick overview Tool useful for any language exams. It is a chat-based workflow that uses Google Sheets in Structure English|your language that using free Groq model (Llama 3.3) generate lists of 10 words that you need to provide answer based on your while model helps How it works Receives a chat message as the trigger input. Checks whether the message contains the word “generate” to decide if it should create a new quiz set or continue the current session. When “generate” is included, reads vocabulary rows (English and your language columns) from a specified Google Sheets range. Randomly shuffles the rows, selects 10 pairs, and formats them as a clean list of {english, your-language} objects. Sends the user message and the selected word pairs to a Groq Llama 3.3 chat model that runs the quiz conversation. Uses a buffer memory window to keep recent chat context so the agent can track which words are answered and which still need guesses. Setup Connect Google Sheets OAuth credentials and set the correct spreadsheet URL, sheet name, and range that contains “English word” and “your language words” columns. Add Groq API credentials and confirm the selected model (llama-3.3-70b-versatile
Track and de-duplicate email leads in Google Sheets from Gmail
Quick overview This workflow polls Gmail for new unread emails with a specific label, extracts lead details from each message, checks Google Sheets for duplicates by email or message ID, and appends only new leads to a designated spreadsheet. How it works Polls Gmail every minute for unread messages matching the search query (for example, emails labeled “Leads”). Extracts sender name and email, subject, message text, phone number (if found), received timestamp, and the Gmail message ID. Reads existing rows from the target Google Sheets tab to compare against previously captured leads. Flags the incoming lead as a duplicate if an existing row matches either the sender email address or the message ID. Appends the lead as a new row in Google Sheets only when it is not flagged as a duplicate. Setup Connect your Gmail OAuth2 credentials and adjust the Gmail trigger query/label and read status filter to match your intake process. Connect your Google Sheets OAuth2 credentials. Update the Google Sheet ID and sheet tab name in the extraction step, and ensure the sheet has columns for Email, Name, Subject, Phone, Message, Received At, and Message ID. Requirements n8n Cloud or self-hosted n8n
Score LinkedIn leads in Google Sheets with Bright Data and Claude
Quick overview This workflow watches a Google Sheets leads sheet, enriches each new lead with LinkedIn person and company data from Bright Data, then uses Anthropic Claude to generate a 0–100 lead score and reason and updates the sheet status to HOT or DONE. How it works Triggers when a new row is added to a Google Sheets worksheet. Reads the leads from the sheet and iterates through the rows that match the configured Status filter. For each lead, uses Bright Data to fetch structured data from the lead’s LinkedIn person profile, then waits briefly to respect rate limits. Uses Bright Data to fetch structured data from the lead’s current company LinkedIn page, then waits briefly to respect rate limits. Sends the person and company details to Anthropic Claude to return a JSON score (0–100) and a one-sentence reason. Parses the JSON response, flags leads with scores ≥ 70 as HOT 🔥 and others as DONE, and writes the enriched fields (title, company, size, location, connections, score, reason) back to Google Sheets. Setup Connect Google Sheets OAuth credentials (Trigger and Google Sheets) and replace YOUR_GOOGLE_SHEET_ID with your spreadsheet ID. Add a Bright Data API credential and ensur
Fitbit Webhook to Google Sheets
On a webhook, sends an email, fetches Fitbit data, and logs it to Google Sheets.
Scheduled Sheets To MySQL Sync
On a schedule, maps the data, updates Google Sheets, and writes the records to MySQL.
HTTP Data To Google Sheets
Fetches data via HTTP request, maps the fields, and appends rows to Google Sheets.
Webhook To Google Sheets
On an incoming webhook, maps the payload and appends a row to Google Sheets.
Calendar Events To Google Sheets
On a new Google Calendar event, maps the details and appends a row to Google Sheets.
Webhook To Sheets And CSV
On an incoming webhook, appends the payload to Google Sheets and exports a CSV.
Gmail Emails To Google Sheets
On a new Gmail email, extracts the data and appends it to Google Sheets.
Scheduled Google Sheets Update
On a schedule, compiles the data and appends it to Google Sheets.
HTTP Data To Sheets And LinkedIn
On manual run, fetches data via HTTP, logs it to Google Sheets, and publishes a LinkedIn post.
Webhook To Sheets And Airtable
On an incoming webhook, appends the payload to Google Sheets and creates an Airtable record.
Gmail To Airtable And Sheets
On a new Gmail email, creates an Airtable record and logs it to Google Sheets.