Connect TaskMagic and Google Sheets

TaskMagic records a browser task and scrapes the data you point it at. FlowMattic receives what each run sends and writes it to Google Sheets from your WordPress site, so researchers, resellers and lead builders get a growing, de-duplicated list instead of a pile of one-off exports.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in TaskMagic1 trigger

Do this in Google Sheets19 actions

1. TriggerScrape Data from Automation

2. ActionAdd New Row

When TaskMagic fires Scrape Data from Automation, 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

TaskMagic 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

Save each TaskMagic scrape as a row

Whatever the automation collects, such as a product, a listing or a profile, is written to the sheet as one row with the fields you map.

Scrape Data from AutomationAdd New Row

View the template

Turn a scraped list into one row per item

When one run scrapes a whole results page, parse the list and loop over it, so each listing gets its own row rather than one long cell.

Scrape Data from AutomationJSON ParserIteratorAdd New Row

Track competitor prices in the same row

Look the product URL up first. A Router updates the price and date of a product you already track and adds a row only for a new one.

Scrape Data from AutomationLookup Row DataRouterUpdate Row

Skip listings already in the sheet

Scrapers that run daily see the same listings again. Search for the listing ID and let a Filter stop the run when it is already there.

Scrape Data from AutomationLookup Row DataFilterAdd New Row

Clean prices and text before they are stored

Scraped prices come with currency signs and stray spaces. Text Formatter trims them and Number Formatter turns the price into a number the sheet can sort.

Scrape Data from AutomationText FormatterNumber FormatterAdd New Row

Summarise scraped page text with AI

An AI Agent reads a scraped description or review and writes a one-line summary column, so a long research list can be skimmed in minutes.

Scrape Data from AutomationAI AgentAdd New Row

Set up: each scrape as a row

At the end, every time your TaskMagic automation sends scraped data, it is added to your Google Sheet.

Create the sheet
Add a header row for the fields your automation scrapes, for example Title, Price, URL and Scraped at.
Connect Google Sheets
In FlowMattic, open Connects and add a Google Sheets account that can edit the spreadsheet.
Start with Scrape Data from Automation
Create a workflow with this TaskMagic trigger, follow its instructions to send your automation's data to the workflow, then run the automation once.
Map the row
Add Google Sheets Add New Row, map the captured fields to your columns, test the step and switch the workflow on.

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

From TaskMagic	To Google Sheets
title	Title
price	Price
url	URL
scraped_at	Scraped 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 fields are whatever your TaskMagic automation sends, so the mapping above is an example. Change the automation's output and you need to run it once more and remap.
A run that scrapes many items may send them as one list. Check the captured data: if it is a list, add JSON Parser and Iterator before Add New Row.
Scrape only pages and data you are allowed to collect, and respect each site's terms.

TaskMagic

Integration page

Triggers (1)

Scrape Data from AutomationTriggers when the scraped data is sent from automation.

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

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

A list that grows, not a pile of files

Every run adds to the same sheet, with lookups that keep each item in one row.

Cleaning happens on the way in

Formatters and filters tidy scraped text before it is stored, so the sheet is ready to sort and chart.

Frequent scrapes, same cost

FlowMattic runs on your own WordPress site with unlimited runs, so scraping every hour costs no more than once a week.

Common questions

How do I send TaskMagic scraped data to Google Sheets?

Create a FlowMattic workflow with the TaskMagic Scrape Data from Automation trigger, send the automation's data to it, then add Google Sheets Add New Row and map the scraped fields to columns.

Can one scrape create many rows?

Yes. If the automation sends a list of items, parse it with JSON Parser and loop with Iterator, running Add New Row for each item.

Can I update prices instead of adding duplicate rows?

Yes. Search the URL or product ID with Lookup Row Data, then use a Router to run Update Row when the item exists and Add New Row when it does not.

Can I keep a dated history of each price?

Yes. Add a second Add New Row step that writes the product, price and date to a history tab, while the main tab keeps the latest price per product.

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

Start automating TaskMagic 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. TaskMagic integration 1.0.0, Google Sheets integration 2.2.4.