Tracking assigned tasks is key to staying organized and meeting deadlines. A practical way to automate it is to connect your tasks to a Google spreadsheet.
That way, you can see how tasks are progressing, share the information with your team, and check it from anywhere.
💡 What do I need to do?
If you need to... | Do this |
Connect your tasks to a Google spreadsheet | Use the Google Sheets button in Task Assignments |
See the tasks assigned before the integration | Export them to Excel and import them into your spreadsheet |
Take your tasks to a spreadsheet without connecting it | Use the Export button |
Have forms and tasks in the same Google Sheets file | Use a separate sheet within the same file for each integration |
📌 How do I integrate my tasks with Google Sheets?
Step 1: Prepare your spreadsheet in Google Sheets
Go to Google Sheets and create the spreadsheet where you want to receive the data.
To ensure a proper, private, and secure integration, share your document with editor permissions only with
datascope-sheets@datascope-io.iam.gserviceaccount.com.Copy your spreadsheet's link.
Step 2: Set up the integration in DataScope
Log in to the DataScope Web Platform.
Go to Task Assignments.
Select the Google Sheets button.
In the Assigned Tasks Integration window, paste your spreadsheet's link in the New link field.
Select Save.
The window shows you the service account to share your spreadsheet with, and you can copy its address from there. It also includes the Go to Google Sheets link.
Once saved, the link appears in the window with icons to copy or delete it.
📌 Important: when you set up the integration, the spreadsheet doesn't bring data right away. Data is added as tasks are created.
📋 Data your spreadsheet will have
Column | What it indicates |
Unique Code | Code that enables the connection between DataScope and Google Sheets. It must not be modified. |
ID To Update Task | The assigned task's ID. |
Form Name | Form the assigned user needs to complete. |
User Email | Email of the user the task was assigned to. |
User Name | Name of the user the task was assigned to. |
Location Code, Location Name, Location Address, Location Email, Location Phone | Details of the location assigned to the task. |
Datetime | Day and time the task needs to be completed. |
Time Gap | Time frame, in hours, the user has to complete the task. |
Description | Description added when assigning the task. |
Checklist | Tasks to perform added when assigning the task. |
Latitude, Longitude | Coordinates of the assigned location. |
Completed | Indicates whether the task was completed: y (yes) or n (no). |
Delay Time (m) | Minutes of delay in completing the form, after the defined time. |
Completed Datetime | Date and time the form was completed. |
Time to Perform (m) | Minutes the user took to complete the form. |
Datetime Start | Date and time of the first response. |
Datetime End | Date and time of the last response. |
Datetime Assign Created | Date and time the task was assigned. |
Created By | User who assigned the task. |
Response Code | Code of the generated form. |
State | The task's status: pending, completed, or incomplete. |
📥 How do I send my older tasks?
Tasks assigned before the first integration don't appear in the spreadsheet. To see them, export the tasks from DataScope and import them into your spreadsheet:
In Task Assignments, filter the date range you need.
Select Export. The tasks whose execution date falls within the applied date range are exported. You can change the file's name before exporting.
Download the Excel (.xlsx) file.
In your Google Sheets spreadsheet, go to File > Import, upload the file, choose Replace spreadsheet, and select Import data.
Check the Datetime, Time Gap, Completed, State columns and the rest of the tasks' data.
📌 Important: when importing, existing data isn't modified: new rows are added with the changes to those tasks.
To learn how to export the list of tasks, see: How do I export the list of assigned tasks?
🕒 Time zone and date format
To avoid incorrect values such as #VALUE! in the Delay Time (m) and State columns, set your spreadsheet's time zone: File > Settings > General > Time zone, and select Save and reload.
Also check the spreadsheet's Locale, in the same place. In spreadsheets with a month/day format, dates with a day of 12 or less may appear with the day and month swapped. Choose a locale with a day/month format.
💡 Tip: forms and tasks in the same file
If you need to have forms and assigned tasks integrated in the same Google Sheets file, you can: each integration goes in a separate sheet within the same file.
❓ Frequently asked questions
My spreadsheet is empty after integrating it, is that normal? Yes. The spreadsheet doesn't bring data right away. Data is added as tasks are created.
Who should I share my spreadsheet with? To ensure a proper, private, and secure integration, share your document with editor permissions only with
datascope-sheets@datascope-io.iam.gserviceaccount.com. You can copy the address from the integration window.I see #VALUE! in Delay Time (m) or State, what do I do? Set your spreadsheet's time zone: File > Settings > General > Time zone.
Dates appear with the day and month swapped, why? The spreadsheet probably has a locale with a month/day format. Change it to one with a day/month format under File > Settings > General > Locale.
How do I see the tasks I assigned before integrating? Export them from Task Assignments and import them into your spreadsheet with File > Import.
Can I integrate forms and tasks in the same file? Yes. Each integration goes in a separate sheet within the same file.
How do I change or delete my spreadsheet's link? Select the Google Sheets button in Task Assignments. The saved link has icons to copy or delete it.