Google Sheets + Streamtime

Create new Streamtime jobs from new rows in Google Sheets

Increase efficiency and productivity with this workflow. When a new row is added to your Google Sheets, a corresponding task is instantly generated in the Streamtime app. This strategy eliminates the need for any manual data transfer, ensuring a fast start to your projects and accurate data transfer from your sheets. Incorporate this seamless transfer process into your operations to boost your efficiency.

When this happens...
New Spreadsheet Row
Triggers when a new row is added to the bottom of a spreadsheet.
TriggerInstant
automatically do this!
Create Job
Creates a new Job in the system.
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

- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
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

- Drive
- SpreadsheetRequired
- WorksheetRequired
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Source RangeRequired
- Destination RangeRequired
- Paste Type
Action
Write

- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Validation TypeRequired
- Input Message
- Strict Validation
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Spreadsheet IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
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
- Tax Number
- 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
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Condition TypeRequired
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Confirm DeletionRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Format TypeRequired
Action
Write
- SpreadsheetRequired
- WorksheetRequired
- New Sheet NameRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Sort by ColumnRequired
- Sort OrderRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
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