Google Sheets integration

What the Google Sheets package does

Google Sheets (an online spreadsheet app that allows you to store and organize different types of information) entegration to perform data operations.

Namespace

Robomotion.GoogleSheets

Latest version

1.7.0 (31 versions published)

Written in

Go

Categories

Productivity

Google Sheets nodes (25)

These are the node IDs an agentic flow or an RPA bot uses, exactly as they appear in the Flow Designer and in flow code. A trigger node has no input port and starts the flow when its event arrives. The Toolkit node hands an agent several of the package operations at once.

Platforms

The Google Sheets package runs on Windows, macOS and Linux robots. Any Robomotion robot on these operating systems can run a flow that uses it.

How to install the Google Sheets package

1. Open Packages in the Robomotion Flow Designer.
2. Search for Google Sheets or Robomotion.GoogleSheets, then click Install on its card.
3. The Google Sheets nodes appear in the node palette for everyone in the workspace, because installation is per workspace.

From a terminal, the Robomotion CLI installs the same package:

robomotion install Robomotion.GoogleSheets

Templates that use Google Sheets

32 ready-made templates use Google Sheets nodes in their flows. Open one to start from a working flow.

• Add Backlinks to Google Sheets

  Pulls the live backlinks pointing at a domain every 15 minutes and appends them to a Google Sheet, one row per link, with the source page, anchor text, follow status, ranks and first/last seen dates.

• AI Mode References to Sheets

  Tracks which websites Google's AI Mode cites when it answers a question. Every 7 days it queries the AI Mode SERP for a keyword, flattens the references of every answer block, de-duplicates them by URL and appends them to a Google Sheet.

• AI Overview Citations to Sheets

  Tracks which websites Google's AI Overview cites for a keyword. Every 7 days it pulls the Google SERP with the AI Overview block loaded, collects every source the answer references, de-duplicates them by URL and appends them to a Google Sheet.

• AI Overview Keyword Wins by Email

  Each week, finds the keywords where your domains are newly cited inside Google's AI Overview, saves the full picture to Google Sheets, and emails the new placements.

• Broken Backlink Recovery Tasks

  Pulls every backlink pointing at a URL on your domain that now returns an error, logs them to a dated Google Sheet, and opens one Asana task pointing at that sheet.

• Bulk Domain Backlink Profiles

  Reads a column of domains from a Google Sheet and pulls the full backlink profile for all of them in one DataForSEO call - rank, spam score, broken links, referring domains, IPs, subnets and the TLD, type, attribute, platform, location and country breakdowns.

• Bulk Domain Rank Checker

  Reads a column of target domains from a Google Sheet, scores all of them in one DataForSEO Bulk Ranks call, and writes each rank back next to its domain with the date it was measured.

• Bulk Domain Spam Score Checker

  Reads a column of domains from a Google Sheet, scores all of them in one DataForSEO Bulk Spam Score call, and writes each 0-100 score back next to its domain with the date it was measured.

• Bulk Live Backlink Counts

  Reads a column of domains from a Google Sheet and pulls the live backlink count for all of them in one DataForSEO call, stamping each count with the date it was measured.

• Bulk Referring Domain Data

  Reads a column of domains from a Google Sheet and pulls the live referring-domain counts for all of them in one DataForSEO call, writing the follow and nofollow breakdown back next to each domain.

• Featured Snippet Wins by Email

  Each week, finds the keywords where your domains now hold Google's featured snippet and emails the new ones with position, search volume and the ranking URL.

• Google Ads Metrics to Sheets

  Reads a column of keywords from a Google Sheet and fills in the Google Ads planner numbers for all of them in one call: monthly search volume, competition and cost per click.

• High-Volume Keywords to Asana Tasks

  Each week, finds the keywords above your search-volume bar that your domains have started ranking for and turns them into an Asana task, so the opportunity lands in someone's queue instead of a spreadsheet nobody opens.

• Keyword Cluster by URL

  Every two weeks, takes a list of URLs from an input sheet and, for each one, pulls the full set of keywords that URL ranks for into its own tab of an output spreadsheet - keyword, position, volume, difficulty, CPC, competition, intent, SERP feature type and estimated traffic.

• Keyword Position Dynamics by URL

  Every two weeks, checks where each tracked URL ranks for its keyword and appends a dated row carrying the new position, the delta and a status - up, down, same, new or lost.

• Low-Competition Keyword Finder

  For each seed domain in an input sheet, pulls every keyword the domain is relevant for, scores all of them for ranking difficulty in one bulk call, and writes the combined picture - volume, trend, difficulty, intent and average backlinks - to an opportunities sheet.

• New AI Overview Keywords by Email

  Each week, finds the keywords where your domains are now cited inside Google's AI Overview and emails the new ones.

• New Featured Snippet Keywords by Email

  Each week, finds the keywords where your domains now hold Google's featured snippet - position zero, above the first organic result - and emails the ones that are new since last week.

• New High-Volume Ranked Keywords

  Each week, finds the keywords above your search-volume bar that your domains have started ranking for, opens one Asana task holding the list, and posts a summary to Slack.

• New Ranked Keywords to Slack

  Each week, pulls every keyword your target domains rank for, compares it against last week's snapshot, and posts whatever is new to Slack.

• New Top-10 Keywords to Airtable

  Each week, finds the keywords where your domains have broken into Google's first page, writes them to an Airtable base, and posts a summary to Slack.

• Scrape AI Mode References

  Watches, in near real time, which sites Google's AI Mode pulls from when it answers questions about your brand. Polls the AI Mode SERP every 15 minutes and appends every cited source to a Google Sheet.

• Scrape AI Overview References

  Polls the Google SERP for a keyword every 15 minutes with the AI Overview block loaded and appends every source the overview cites to a Google Sheet.

• Slack Alert on Keyword Rank Drop

  Every morning, checks where each tracked URL ranks for its keyword, compares against the position recorded on the last run, and posts to Slack only when a keyword has moved down.

• Top-10 Keywords to Airtable with Slack Alerts

  Each week, finds the keywords where your domains have broken into Google's first page, logs them to Airtable, and alerts Slack.

• Top-10 Rank Drop Alert via Gmail

  Every day, pulls the keywords each target domain currently holds a top-10 position for, compares against yesterday's snapshot, and emails a digest of everything that slipped.

• Top-10 Rank Drop Alerts by Email

  Every day, pulls the keywords each target domain currently holds a top-10 position for, compares against yesterday's snapshot, and emails a digest of everything that slipped.

• Track New and Lost Backlinks

  Reads a column of domains from a Google Sheet and pulls, in one DataForSEO call, how many backlinks each of them gained and lost, stamped with the date.

• Track New and Lost Referring Domains

  Reads a column of domains from a Google Sheet and pulls, in one DataForSEO call, how many referring domains each of them gained and lost - counted both per domain and per main domain - stamped with the date.

• Track New Ranked Keywords with Slack Alerts

  Once a week, fetches every keyword your domains rank for on Google, saves the current picture to Google Sheets, and sends a Slack summary of what is newly ranking.

• Weekly Toxic Backlink Report

  Every week, pulls every backlink first seen in the last seven days whose spam score is above the threshold, drops them into a fresh Google Sheet named after the domain and the date, and emails you the link.

• SSL Watch

  SSL Watch is an automation that monitors domain expiration dates and SSL certificate validity using Robomotion's Monitoring package. It checks each domain, calculates days until expiration, verifies certificate status, and updates a Google Sheets file automatically through secure Vault stored credentials.

Related integrations

Packages that share a category or keywords with Google Sheets. It is filed under Productivity.

• Microsoft Excel 365Connects to Microsoft Excel 365 via Microsoft Graph API to manage workbooks, worksheets, tables, and ranges in OneDrive and SharePoint.
• Microsoft Excel DesktopMicrosoft Excel organizes data in columns and rows that can be manipulated through formulas that allow the software to perform mathematical functions on the data.
• Agent TeamsConnects an agent flow to the Agent Teams collaboration plane: heartbeat-driven mention dispatch, real-time channel push, ticket updates, and task scheduling.
• Agent ToolsComprehensive toolset for AI agents to perform file operations，code editing，web research，and task management across platforms.
• AirtableConnects to Airtable for CRUD operations on Airtable records. Supports listing bases, getting schema, bulk operations, comments, and formula-based search.
• AsanaConnect to Asana to manage workspaces, projects, sections, tasks, comments and users

Google Sheets documentation

The Google Sheets package reference on docs.robomotion.io documents each node and its properties.