actiTIME + Google Sheets

Create spreadsheet rows in Google Sheets for new actiTIME tasks

If you want to have a daily back up of your actiTIME tasks with all their details, then you can easily make it using this Zapier integration. Google Sheets rows will be created every time a new task is created in actiTIME so you can save these data for further purposes.

When this happens...
New Task
Triggers when a new task is created.
TriggerInstant
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Try this template

Supported triggers and actions

What does this mean?

New Customer
Triggers when a new customer is created.
Trigger
Instant
New Project
Triggers when a new project is created.
Trigger
Instant
New Task
Triggers when a new task is created.
Trigger
Instant
New User
Triggers when a new user is created.
Trigger
Instant
Updated Leave Time
Triggers when the user's leave time is changed.
Trigger
Instant
Updated Task
Triggers when an existing task is changed.
Trigger
Instant
Updated Time-Track
Triggers when the user's working time is changed.
Trigger
Instant
Updated Time-Track's Status (Ready for Approval)
Triggers when the weekly time-track's status is changed to the 'Ready for Approval' status.
Trigger
Instant
actiTIME
Creates a new customer.
Scheduled
Action
actiTIME
Creates a new project.
Scheduled
Action
actiTIME
Creates a new task.
Scheduled
Action
actiTIME
Modifies the leave time record by increasing the existing value by a specified value.
Scheduled
Action
actiTIME
Modifies the leave time record by replacing the existing value with a specified one.
Scheduled
Action
actiTIME
Modifies the time-track record by increasing the existing value by a specified value.
Scheduled
Action
actiTIME
Modifies the time-track record by replacing the existing value with a specified one (along with the time-track record comment).
Scheduled
Action
actiTIME
Finds the customer by name.
Scheduled
Action
actiTIME
Finds project by name
Scheduled
Action
actiTIME
Finds the task by name.
Scheduled
Action
actiTIME
Finds the customer by name.
Scheduled
Action
actiTIME
Finds project by name
Scheduled
Action
actiTIME
Finds the task by name.
Scheduled
Action
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new spreadsheet.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new worksheet in a spreadsheet.
Scheduled
Trigger
Google Sheets
Create a new column in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create a new row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action