This workflow helps you keep track of new backlinks by automatically generating a daily report in Google Sheets with the DataForSEO API, and delivering it via Gmail. On each run, the workflow connects to the DataForSEO Backlinks API to retrieve the latest backlink data for your target domain or URL. It then organizes the results into a structured Google Sheets report, complete with key backlink metrics such as referring source URL, referring domain, spam score, domain rating (DR), and dofollow link attributes where present. Once the report is updated, the workflow automatically sends you an email notification via Gmail with a direct link to the Google Sheet, making it easy to review new links and measure link-building progress day-to-day. Who’s it for This workflow is especially useful for SEO teams, link-building specialists, and website owners who want automated daily overview of new backlinks. What it does This workflow automatically monitors newly detected backlinks and sends you a daily report via email. How it works Triggers automatically on a daily basis. Fetches backlinks for your target domain or URL using the DataForSEO Backlinks API.
Tags
Gmail
Google SheetsRelated workflows
See all Gmail→WMove data between JSON and spreadsheets
This workflow illustrates how to convert data from JSON to binary format and import JSON data or files into Google Sheets or local spreadsheets.
WRoute real estate buyer and seller leads with Claude and Google Sheets
Quick Overview This workflow hosts an n8n lead-capture form, uses Anthropic Claude to score and classify real estate inquiries, then routes ready leads to Gmail and Google Sheets while logging early-stage leads to a separate Google Sheets tab. How it works Receives a new submission from an n8n Form trigger with contact details, intent, area, budget, timeline, financing status, and notes. Normalizes the submitted fields (for example trimming strings, lowercasing email, and adding a timestamp) for consistent downstream processing. Sends the normalized lead details to the Anthropic Messages API (Claude) to return a strict JSON classification, summary, timeline band, financing readiness, recommended agent role, and score. Parses the Claude JSON response, clamps the score to a 1–10 range, and calculates whether the lead is “ready” (score 7). If the lead is ready, sends a formatted Gmail alert to the agent and appends the lead to the “Active Leads” tab in Google Sheets. If the lead is not ready, appends the lead to the “Nurture Leads” tab in Google Sheets. Returns a confirmation message to the form submitter after the lead is routed. Setup Create an Anthropic HTTP Header Auth credential
Send weekly overdue invoice reminders with Google Sheets and Gmail
Quick Overview This workflow runs every Monday at 08:00, reads invoices from Google Sheets, filters for unpaid invoices with no prior follow-up and more than 7 days overdue, sends an HTML reminder email via Gmail, and updates the sheet to mark the invoice as followed up. How it works Runs every Monday at 08:00 on a schedule. Reads all invoice rows from a Google Sheets spreadsheet. Keeps only invoices where the status is “Impayé” and the “Date de relance” field is empty, then calculates the number of days overdue from the invoice date. Filters to invoices that are more than 7 days overdue. Sends a formatted HTML payment reminder email via Gmail with the invoice date, amount, and days overdue. Updates the matching Google Sheets row to set the status to “Relancé” and writes today’s follow-up date. Setup Add Google Sheets credentials and ensure the target spreadsheet contains columns like Statut, Date de relance, Date_Facture, Client, and Montant. Add Gmail credentials for the mailbox that sends reminders. Update the Google Sheets document URL/sheet selection and set the recipient address in the Gmail “sendTo” field (and optionally adapt the subject/body text).