HumationHuman + Automation
Back to Catalog

Automatic backlink data export from Semrush to Google Sheets via RapidAPI

Evoort SolutionsEvoort Solutions
219 views
2/3/2026
SynchronizationTriggerEventsProductivityGoogle Calendar
Official Page

🔗 Automated Semrush Backlink Checker with n8n and Google Sheets

📘 Description

This n8n workflow automates backlink data extraction using the Semrush Backlink Checker API available on RapidAPI. By submitting a website via a simple form, the workflow fetches both backlink overview metrics and detailed backlink entries, saving the results directly into a connected Google Sheet. This is an ideal solution for SEO professionals who want fast, automated insights without logging into multiple tools.

🧩 Node-by-Node Explanation

  • On form submission – Starts the workflow when a user submits a website URL through a web form.
  • HTTP Request – Sends the URL to the Semrush Backlink Checker API using a POST request with headers and form data.
  • Reformat 1 – Extracts high-level backlink overview data like total backlinks and referring domains.
  • Reformat 2 – Extracts individual backlink records such as source URLs, anchors, and metrics.
  • Backlink overview – Appends overview metrics into the "backlink overflow" tab of a Google Sheet.
  • Backlinks – Appends detailed backlink data into the main "backlinks" tab of the same Google Sheet.

✅ Benefits of This Workflow

  • No-code integration: Built entirely within n8n—no scripting required.
  • Time-saving automation: Eliminates the need to manually log in or export reports from Semrush.
  • Centralized results: All backlink data is organized in Google Sheets for easy access and sharing.
  • Powered by RapidAPI: Uses the Semrush Backlink Checker API hosted on RapidAPI for fast, reliable access.
  • Easily extendable: Can be enhanced with notifications, dashboards, or additional data enrichment.

🛠️ Use Cases

  • 📊 SEO Audit Automation – Auto-generate backlink insights for multiple websites via form submissions.
  • 🧾 Client Reporting – Streamline backlink reporting for SEO agencies or consultants.
  • 📥 Lead Capture Tool – Offer a free backlink analysis tool on your site to capture leads while showcasing value.
  • 🔁 Scheduled Backlink Monitoring – Modify the trigger to run on a schedule for recurring reports.
  • 📈 Campaign Tracking – Monitor backlinks earned during content marketing or digital PR campaigns.

🔐 How to Get Your API Key for the Competitor Keyword Analysis API

  1. Go to 👉 Semrush Backlink Checker API - RapidAPI
  2. Click "Subscribe to Test" (you may need to sign up or log in).
  3. Choose a pricing plan (there’s a free tier for testing).
  4. After subscribing, click on the "Endpoints" tab.
  5. Your API Key will be visible in the "x-rapidapi-key" header.

🔑 Copy and paste this key into the httpRequest node in your workflow.

Create your free n8n account and set up the workflow in just a few minutes using the link below:

👉 Start Automating with n8n

Save time, stay consistent, and grow your LinkedIn presence effortlessly!

n8n Form Trigger to Google Sheets

This n8n workflow provides a simple way to capture data submitted through an n8n form and automatically append it to a Google Sheet. It's ideal for quickly collecting information, feedback, or sign-ups without needing a complex backend.

What it does

  1. Listens for Form Submissions: The workflow is triggered whenever a user submits data through an n8n form.
  2. Processes Submitted Data: It takes the data received from the form.
  3. Appends to Google Sheet: The submitted data is then added as a new row to a specified Google Sheet.

Prerequisites/Requirements

  • n8n Instance: You need a running n8n instance to import and execute this workflow.
  • Google Account: A Google account with access to Google Sheets is required.
  • Google Sheets Credential: An n8n credential for Google Sheets, configured with appropriate permissions to write to your desired spreadsheet.

Setup/Usage

  1. Import the Workflow:
    • Download the provided JSON file.
    • In your n8n instance, go to "Workflows" and click "New".
    • Click the "Import from JSON" button and upload the downloaded JSON file.
  2. Configure the n8n Form Trigger:
    • Click on the "n8n Form Trigger" node.
    • Design your form by adding the necessary fields (e.g., text inputs, email fields).
    • Save the form. You will get a shareable URL for your form.
  3. Configure Google Sheets Node:
    • Click on the "Google Sheets" node.
    • Select your Google Sheets credential. If you don't have one, create a new OAuth2 or Service Account credential for Google Sheets.
    • Set the "Operation" to "Append Row".
    • Specify the "Spreadsheet ID" and "Sheet Name" where you want the data to be added.
    • Map the data from the "n8n Form Trigger" node to the columns in your Google Sheet. You can use expressions like {{ $json.fieldName }} where fieldName is the name of your form field.
  4. Activate the Workflow:
    • Ensure the workflow is active by toggling the "Active" switch in the top right corner of the workflow editor.
  5. Test the Workflow:
    • Open your n8n form URL in a browser.
    • Fill out the form and submit it.
    • Check your Google Sheet to confirm that the data has been added correctly.

Related Templates

Create Dynamic Seating & Venue Layout Plans with Google Sheets

Enhance event logistics with this automated n8n workflow. Triggered by seating requests, it fetches attendee data and venue templates from Google Sheets, calculates totals, and optimizes seating layouts. The workflow generates detailed recommendations, splits individual assignments, and sends alerts, ensuring efficient venue planning and real-time updates. 🎪📋 Key Features Optimizes seating arrangements based on attendee data and event type. Generates venue layouts with visual and statistical insights. Provides real-time alerts with comprehensive seating plans. Logs detailed assignments and layouts in Google Sheets. Workflow Process The Webhook Trigger node initiates the workflow upon receiving venue requirements and attendee data via webhook. Validate Request Data ensures the incoming data is complete and accurate. Fetch Attendee Data retrieves attendee information, including groups, accessibility needs, and VIP preferences from Google Sheets. Fetch Venue Templates reads venue layout templates from Google Sheets. Calculate Totals aggregates attendee data and venue constraints for optimal planning. Combine All Data merges attendee and venue data for analysis. AI Optimization uses algorithms to calculate optimal seating based on venue dimensions, attendee groups, accessibility needs, VIP placement, and aisle placement. Optimize Seating Layout refines the seating plan for efficiency. Format Recommendations structures the seating plan with visual layout map, seat assignments, statistics & metrics, and optimization tips. Split Seat Assignments divides the plan into individual seat assignments. Send Response returns the complete seating plan with visual layout map, seat assignment list, statistics & recommendations, and export-ready format. Send Alert notifies organizers with the finalized plan details. Update Sheets saves the master plan summary, individual seat assignments, and layout specifications to Google Sheets. Save Individual Assignments appends or updates individual seat assignments to Google Sheets. Setup Instructions Import the workflow into n8n and configure Google Sheets OAuth2 for data access. Set up the Webhook Trigger with your event management system's API credentials. Configure the AI Optimization node with a suitable algorithm or model. Test the workflow by sending sample seating requests and verifying layouts. Adjust optimization parameters as needed for specific venue or event requirements. Prerequisites Google Sheets OAuth2 credentials Webhook integration with the event management system Structured attendee and venue data in a Google Sheet Google Sheet Structure: Attendee Data Sheet with columns: Name Group Accessibility Needs VIP Status Preferences Updated At Venue Templates Sheet with columns: Venue Name Capacity Dimensions Layout Template Updated At Modification Options Customize the Validate Request Data node to include additional validation rules. Adjust the AI Optimization node to prioritize specific criteria (e.g., proximity, accessibility). Modify the Format Recommendations node to include custom visual formats. Integrate with venue management tools for live layout updates. Set custom alert triggers in the Send Alert node. Discover more workflows – Get in touch with us

Oneclick AI SquadBy Oneclick AI Squad
395

AI meeting summary & action item tracker with Notion, Slack, and Gmail

How it Works This workflow accepts meeting transcripts via webhook (Zoom, Google Meet, Teams, Otter.ai, or manual notes), immediately processing them through an intelligent pipeline that eliminates post-meeting admin work. The system parses multiple input formats (JSON, form data, transcription outputs), extracting meeting metadata including title, date, attendees, transcript content, duration, and recording URLs. OpenAI analyzes the transcript to extract eight critical dimensions: executive summary, key decisions with ownership, action items with assigned owners and due dates, discussion topics, open questions, next steps, risks/blockers, and follow-up meeting requirements—all returned as structured JSON. The intelligence engine enriches each action item with unique IDs, priority scores (weighing urgency + owner assignment + due date), status initialization, and meeting context links, then calculates a completeness score (0-100) that penalizes missing owners and undefined deadlines. Multi-channel distribution ensures visibility: Slack receives formatted summaries with emoji categorization for decisions (✅), action items (🎯) with priority badges and owner assignments, and completeness scores (📊). Notion gets dual-database updates—meeting notes with formatted decisions and individual task cards in your action item database with full filtering and kanban capabilities. Task owners receive personalized HTML emails with priority color-coding and meeting context, while Google Calendar creates due-date reminders as calendar events. Every meeting logs to Google Sheets for analytics tracking: attendee count, duration, action items created, priority distribution, decision count, completeness score, and follow-up indicators. The workflow returns a JSON response confirming successful processing with meeting ID, action item count, and executive summary. The entire pipeline executes in 8-12 seconds from submission to full distribution. --- Who is this for? Product and engineering teams drowning in scattered action items across tools Remote-first companies where verbal commitments vanish after calls Executive teams needing auditable decision records without dedicated note-takers Startups juggling 10+ meetings daily without time for manual follow-up Operations teams tracking cross-functional initiatives requiring accountability --- Setup Steps Setup time: 25-35 minutes Requirements: OpenAI API key, Slack workspace, Notion account, Google Workspace (Calendar/Gmail/Sheets), optional transcription service Webhook Trigger: Automatically generates URL, configure as POST endpoint accepting JSON with title, date, attendees, transcript, duration, recording_url, organizer Transcription Integration: Connect Otter.ai/Fireflies.ai/Zoom webhooks, or create manual submission form OpenAI Analysis: Add API credentials, configure GPT-4 or GPT-3.5-turbo, temperature 0.3, max tokens 1500 Intelligence Synthesis: JavaScript calculates priority scores (0-40 range) and completeness metrics (0-100), customize thresholds Slack Integration: Create app with chat:write scope, get bot token, replace channel ID placeholder with your meeting-summaries channel Notion Databases: Create "Meeting Notes" database (title, date, attendees, summary, action items, completeness, recording URL) and "Action Items" database (title, assigned to, due date, priority, status, meeting relation), share both with integration, add token Email Notifications: Configure Gmail OAuth2 or SMTP, customize HTML template with company branding Calendar Reminders: Enable Calendar API, creates events on due dates at 9 AM (adjustable), adds task owner as attendee Analytics Tracking: Create Google Sheet with columns for MeetingID, Title, Date, Attendees, Duration, ActionItems, HighPriority, Decisions, Completeness, UnassignedTasks, FollowUpNeeded Test: POST sample transcript, verify Slack message, Notion entries, emails, calendar events, and Sheets logging --- Customization Guidance Meeting Types: Daily standups (reduce tokens to 500, Slack-only), sprint planning (add Jira integration), client calls (add CRM logging), executive reviews (stricter completeness thresholds) Priority Scoring: Add urgency multiplier for <48hr due dates, owner seniority weights, customer impact flags AI Prompt: Customize to emphasize deadlines, blockers, or technical decisions; add date parsing for phrases like "by end of week" Notification Routing: Critical priority (score >30) → Slack DM + email, High (20-30) → channel + email, Medium/Low → email only Tool Integrations: Add Jira/Linear for ticket creation, Asana/Monday for project management, Salesforce/HubSpot for CRM logging, GitHub for issue creation Analytics: Build dashboards for meeting effectiveness scores, action item velocity, recurring topic clustering, team productivity metrics Cost Optimization: ~1,200 tokens/meeting × $0.002/1K (GPT-3.5) = $0.0024/meeting, use batch API for 50% discount, cache common patterns --- Once configured, this workflow becomes your team's institutional memory—capturing every commitment and decision while eliminating hours of weekly admin work, ensuring accountability is automatic and follow-through is guaranteed. --- Built by Daniel Shashko Connect on LinkedIn

Daniel ShashkoBy Daniel Shashko
344

Automate Instagram complaint handling with Claude AI, tickets & SLA management

This enterprise-grade n8n workflow automates the Instagram complaint handling process — from detection to resolution — using Claude AI, dynamic ticket assignment, and SLA enforcement. It converts customer complaints in comments into actionable support tickets with auto-assignment, escalation alerts, and full audit trails, ensuring timely responses and improved customer satisfaction with zero manual intervention. Key Features Real-time Instagram polling for new comments AI-powered complaint detection using Claude 3.5 Sonnet for sentiment and issue classification Automatic ticket creation in Google Sheets (or integrable with Zendesk/Jira) Round-robin assignment to team members from a dynamic roster SLA timer and monitoring (e.g., 24-hour response window with escalation at 80% elapsed) Escalation engine notifies managers via Slack if near breach Multi-channel notifications: Slack for assignees and escalations Audit-ready: Logs ticket details, assignments, and actions Scalable triggers: Webhook or scheduled polling Workflow Process | Step | Node | Description | | ---- | ----------------------------------- | -------------------------------------------------------- | | 1 | Schedule Trigger | Runs every 15 minutes or via webhook (/complaint-handler) | | 2 | Get Instagram Posts | Fetches recent posts from Instagram Graph API | | 3 | Get Comments | Retrieves comments for the latest post | | 4 | Loop Over Comments | Processes each comment individually to avoid rate limits | | 5 | Detect Complaint (Claude AI) | Uses AI to classify if complaint, extract issue/severity | | 6 | IF Complaint | Branches: Proceed if yes, end if no | | 7 | Get Team Members | Loads team roster from TeamMembers sheet | | 8 | Assign Ticket | Sets assignee via round-robin logic | | 9 | Create Ticket (Google Sheet) | Appends new ticket with details and SLA due date | | 10 | Notify Assignee (Slack) | Alerts assigned team member | | 11 | Wait for SLA Check | Delays to near-SLA-breach point (e.g., 20 hours) | | 12 | Check Ticket Status | Looks up ticket status in sheet | | 13 | IF SLA Breach Near | Checks if unresolved; escalates if yes | | 14 | Escalate to Manager (Slack) | Notifies manager for urgent action | | 15 | End (Non-Complaint Path) | Terminates non-complaint branches | Setup Instructions Import Workflow Open n8n → Workflows → Import from Clipboard Paste the JSON workflow Configure Credentials | Integration | Details | | ----------------- | -------------------------------------------------- | | Instagram API | Access token from Facebook Developer Portal | | Claude AI | Anthropic API key for claude-3-5-sonnet-20241022 | | Google Sheets | Service account with spreadsheet access | | Slack | Webhook or OAuth app | Update Spreadsheet IDs Ensure your Google Sheets include: SupportTickets TeamMembers Set Triggers Webhook: /webhook/complaint-handler (for real-time Instagram notifications if set up) Schedule: Every 15 minutes Run a Test Use manual execution to confirm: Ticket creation in sheet Slack notifications SLA wait and escalation logic (simulate by shortening wait time) Google Sheets Structure SupportTickets | ticketId | commentText | user | createdAt | assignedTo | status | slaDue | issueType | severity | |--------------|-------------|----------|--------------------|--------------------|--------|--------------------|---------------|----------| | TKT-12345678 | Sample complaint text | user123 | 2023-10-01T12:00:00Z | john@team.com | Open | 2023-10-02T12:00:00Z | Product Issue | Medium | TeamMembers | name | email | |-----------|-------------------| | John Doe | john@team.com | | Jane Smith| jane@team.com | System Requirements | Requirement | Version/Access | | --------------------- | ---------------------------------------------- | | n8n | v1.50+ (AI integrations supported) | | Claude AI API | claude-3-5-sonnet-20241022 | | Instagram Graph API| Business account access token | | Google Sheets API | https://www.googleapis.com/auth/spreadsheets | | Slack Webhook | Required for notifications | Optional Enhancements Integrate Zendesk/Jira for professional ticketing instead of Google Sheets Add email notifications to customers acknowledging complaints Use sentiment thresholds for prioritizing high-severity tickets Connect Twilio for SMS escalations Enable multi-platform support (e.g., Twitter/Facebook comments) Add reporting dashboard via Google Data Studio Implement auto-resolution for simple complaints using AI responses Result: A single automated system that detects, tickets, assigns, and enforces SLAs on Instagram complaints — with full AI intelligence and zero manual work. Explore More AI Workflows: Get in touch with us for custom n8n automation!

Oneclick AI SquadBy Oneclick AI Squad
161