Connecting and exporting data to Google Sheets.

How to export data you scraped during your recordings to your Google Sheets.

What does this do?

TaskMagic integrates seamlessly with Google Sheets, making it easy to access, read, and export data for analysis. By connecting the two, you can streamline your workflow and boost productivity. In this article, we'll show you how to send data from your automation to Google Sheets.

First click View on the Automation you wish to send to your Google Sheets.

 
Notion image
 

Next click Send to Google Sheets¹ at the bottom right side.

 
Notion image
 
⚠️
You must have at least one header in row 1 of your google sheet whether it is importing or exporting data, it doesn't matter what the header says or the number of headers, we just need at least one header.
 
Notion image
 

You will be prompted to connect to a Google Sheet via URL to send the data to this sheet.

 
Notion image
 
👇
Note: All sheets are going to need to be shared via URL and shared with automations@taskmagic.com.
 

Once you connect your sheet, double check that all the information is correct. If everything is correct, click on Looks good¹.

Notion image
 

And you are all set. Once you’ve clicked on the button, all the information you scraped will be stored in that Google Sheet you selected.

Did this answer your question?
😞
😐
🤩