Connect Runscope and Google Sheets

Runscope runs your API tests on a schedule and reports each completed Radar run. FlowMattic writes every run to Google Sheets, so your team keeps a long test history, can chart response times, and has a status board showing whether each API test passed last time, readable by people who never open Runscope.

Try FlowMattic free See example workflows

7 triggers 19 actions 5 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Runscope1 trigger

Do this in Google Sheets19 actions

1. TriggerNew Completed Radar Test Run

2. ActionAdd New Row

When Runscope fires New Completed Radar Test Run, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Runscope and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Ready-made template

Log every completed Runscope Radar test run

Each run adds a row with test name, result, environment and time, building a history of your API checks you can filter and chart.

New Completed Radar Test RunAdd New Row

View the template

Collect failed runs on a failures tab

A Filter passes only runs that did not pass, so the on-call developer reviews a short list of failures instead of every run.

New Completed Radar Test RunFilterAdd New Row

Show the latest result of each test on a status board

Find the test by name in a status tab and overwrite its result and time, so product managers see which APIs are passing now.

New Completed Radar Test RunLookup Row DataUpdate Row

Record response times in readable seconds

Number Formatter converts millisecond timings and rounds them before they are written, so latency charts in the sheet read cleanly.

New Completed Radar Test RunNumber FormatterAdd New Row

Split runs by bucket or environment

A Router sends production and staging runs to separate tabs, so a broken staging build does not crowd the production history.

New Completed Radar Test RunRouterAdd New Row

Set up: a row for every test run

At the end, each completed Radar test run adds a row to your test history sheet.

Create the history tab
Add headers such as Test, Environment, Result, Response time and Finished at.
Connect Google Sheets
Under Connects, add a Google account with edit access to the file.
Choose the Radar trigger
Create a workflow with New Completed Radar Test Run and follow the setup shown in the trigger step.
Run a test
Start a Radar test in Runscope so FlowMattic captures a completed run.
Map and turn on
Add Google Sheets Add New Row, map the run fields, test the step and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up

From Runscope	To Google Sheets
Test name	Test
Environment	Environment
Result	Result
Response time	Response time
Finished at	Finished at

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

The trigger fires for passing and failing runs alike. Add a Filter on the result if you only want failures.
Field names come from Runscope's run data, so check a captured run before you map. The mapping above is an example.
Tests that run every minute write many rows. Use a status tab with Update Row if you only need the latest result.

Runscope

Integration page

Triggers (1)

New Completed Radar Test RunTriggers when the radar API test completes a run.

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

Runscope and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Test results on your server

Run data passes through your WordPress site to the sheet, not through another automation account.

Frequent schedules cost the same

Runs are unlimited, so tests every few minutes across many APIs need no bigger plan.

A status board for everyone

Product and support staff check the sheet instead of asking developers whether an API is up.

Common questions

How do I send Runscope test results to Google Sheets?

Create a workflow with the Runscope New Completed Radar Test Run trigger, run a test, then add Google Sheets Add New Row and map the test, result and timing fields.

Can I log only failed tests?

Yes. Add a Filter after the trigger that passes runs whose result is not a pass, then write those runs to a failures tab.

Can I see only the latest result for each test?

Yes. Keep one row per test in a status tab. Find it with Lookup Row Data and overwrite the result with Update Row on each run.

Will a large history slow the sheet down?

Very large tabs get slower to open. Export the history now and then with Export sheet to CSV and clear old rows, or keep a status tab instead.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Runscope and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Runscope integration 1.0.0, Google Sheets integration 2.2.4.