Google Sheets + Streamtime

Create Google Sheets rows for new Streamtime job entries

This workflow initiates once a new job is added in Streamtime. It then helps to streamline your project tracking by instantaneously creating a corresponding row in your Google Sheets document. This allows for a seamless organization of your projects, ensuring you have an up-to-date, comprehensive overview of all your jobs added to Streamtime in one Google Sheets location.

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

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

Company Updated
Triggers when a Company is modified.
Trigger
Instant
Try It
Contact Updated
Triggers when a Contact is updated.
Trigger
Instant
Try It
Invoice Sent
Triggers when an Invoice is sent to a client.
Trigger
Instant
Try It
Job Created
Triggers when a Job is created.
Trigger
Instant
Try It
- Activity Type
- User
- Company
- Job Name
Trigger
Instant
Try It

- Label Type
- Label Name
Trigger
Instant
Try It
Quote Approved
Triggers when a Quote gets approved.
Trigger
Instant
Try It

- NameRequired
- Phone 1
- Phone 2
- Website Address
- Notes
- Postal Address Line 1
- Postal Address Line 2
- Postal Address Line 3
- Postal Address City
- Postal Address Post Code
- Postal Address Country
- Postal Address Region
- Physical Address Line 1
- Physical Address Line 2
- Physical Address Line 3
- Physical Address City
- Physical Address Region
- Physical Address Country
- Physical Address Post Code
Action
Write
- Job NameRequired
- Job Number
- Company NameRequired
- Budget
Action
Write
- Job IDRequired
- Expense NameRequired
- Description
- Reference
- Company
- Date
- Pricing MethodRequired
- StatusRequired
- Currency Code
- QuantityRequired
- Cost Rate
- Sell Rate
- Markup
- Total (ex tax)
Action
Write
- NotesRequired
- Date
- Duration (minutes)
- StatusRequired
Action
Write
- Label TypeRequired
- IDRequired
- NameRequired
Action
Write
- Priority Board IDRequired
- ColumnRequired
- Card TypeRequired
- ID
- Notes
Action
Write
- Branch Name
Action
Search
- Company Name
Action
Search
- Invoice Number
- Invoice Name
Action
Search
- Expense Name
- Company Name
Action
Search
- First Name
- Last Name
- Email
Action
Search
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy To
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Search or write

Company Created
Triggers when a Company is created
Trigger
Instant
Try It
Contact Created
Triggers when a Contact is created
Trigger
Instant
Try It
- User
Trigger
Instant
Try It
Job Deleted
Triggers when a Job is deleted.
Trigger
Instant
Try It
- Mentioned User
Trigger
Instant
Try It
- Label Type
- Label Name
Trigger
Instant
Try It
Quote Sent
Triggers when a Quote is sent to a client.
Trigger
Instant
Try It
- CompanyRequired
- First NameRequired
- Last Name
- Email
- Phone Number
- Position
Action
Write
- Job IDRequired
- Post TitleRequired
- MessageRequired
Action
Write
- Board NameRequired
Action
Write
- Job IDRequired
- MessageRequired
Action
Write
- User
- Notes
- Date
- Duration (minutes)
- StatusRequired
- Job IDRequired
- Item Name
Action
Write
- Job IDRequired
- Company NameRequired
- New Job NameRequired
- New Job Number
- Start Date
- How would you like to affect the rates on your existing items and expenses?Required
Action
Write
- Priority Board NameRequired
Action
Search
- Company Name
- First Name
- Last Name
- Email
Action
Search
- Job Number
- Job Name
Action
Search
- Quote Name
- Quote Number
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search or write

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more Help

Related categories

Similar apps

Zapier Tables

Databases, Spreadsheets, Zapier

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

About Streamtime

Intuitive project management, time tracking with auto-populated to-do lists, deep analytics, team scheduling and much more.

Learn more Help

Related categories

Project Management

Similar apps

Trello

Project Management

Asana

Project Management

Todoist

Task Management

PRODUCTS

CAPABILITIES

By team

Google Sheets + Streamtime

Create Google Sheets rows for new Streamtime job entries

Company Updated

Contact Updated

Invoice Sent

Job Created

Job Activity

Activity Type

User

Company

Job Name

Label Added

Label Type

Label Name

Quote Approved

Create Company

Phone 1

Phone 2

Website Address

Notes

Postal Address Line 1

Postal Address Line 2

Postal Address Line 3

Postal Address City

Postal Address Post Code

Postal Address Country

Postal Address Region

Physical Address Line 1

Physical Address Line 2

Physical Address Line 3

Physical Address City

Physical Address Region

Physical Address Country

Physical Address Post Code

Create Job

Job NameRequired

Job Number

Company NameRequired

Budget

Create Expense

Job IDRequired

Expense NameRequired

Description

Reference

Company

Date

Pricing MethodRequired

StatusRequired

Currency Code

QuantityRequired

Cost Rate

Sell Rate

Markup

Total (ex tax)

Create Personal ToDo

NotesRequired

Date

Duration (minutes)

StatusRequired

Add Label

Label TypeRequired

IDRequired

NameRequired

Create Priority Board Card

Priority Board IDRequired

ColumnRequired

Card TypeRequired

ID

Notes

Find Branch

Branch Name

Find Company

Company Name

Find Invoice

Invoice Number

Invoice Name

Find Expense