Google Sheets + Scoro

Google Sheets + Scoro integrations

Create or update companies and/or persons in Scoro from new Google Sheets rows

Activate this Zap to automatically create new companies and contacts from the details added to new Google Sheets rows. This comes in handy when you have a Google Form for collecting contact information from new leads or event participants, and you want to have these contacts in Scoro to be able to contact them with quotes or offers.

When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstant
automatically do this...
Find CompanySearch for a company by name.
ActionSearch
then do this...
Create or Update CompanyCreates a new company or updates an existing one.
ActionWrite
then do this...
Find PersonFind person by full name, email or ID.
ActionSearch
then do this!
Create or Update PersonCreates a new person or updates an existing one if e-mail address of the person match.
ActionWrite

Start free with email

Start free with Google

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

More things you can do with Google Sheets and Scoro

Discover other triggers and actions you can use with Google Sheets and Scoro

- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Column_name
  Required
- Index
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write

- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Source Range
  Required
- Destination Range
  Required
- Paste Type
Action
Write

- Drive
- Title
  Required
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Validation Type
  Required
- Input Message
- Strict Validation
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Columns
  Required
- Row count
  Required
- Output format
- First row
Action
Search
- Spreadsheet ID
  Required
- Include Grid Data
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
New or Updated Bill
Triggers when a bill is created or modified.
Trigger
Instant
Try It
New or Updated Calendar Event
Triggers when a calendar event is created or modified.
Trigger
Instant
Try It
New or Updated Company
Triggers when a company is created or modified.
Trigger
Instant
Try It
New or Updated Custom Entry
Triggers when a Custom entry is created or modified.
Trigger
Instant
Try It
New or Updated Invoice
Triggers when an invoice is created or modified.
Trigger
Instant
Try It
New or Updated Order
Triggers when an order is created or modified.
Trigger
Instant
Try It
New or Updated Person
Triggers when a person is created or modified.
Trigger
Instant
Try It
New or Updated Project
Triggers when a project is created or modified.
Trigger
Instant
Try It
New or Updated Purchase Order
Triggers when an purchase order is created or modified.
Trigger
Instant
Try It
New or Updated Quote
Triggers when an quote is created or modified.
Trigger
Instant
Try It
New or Updated Task
Triggers when a task is created or modified.
Trigger
Instant
Try It
Create or Update Bill
Creates a new bill or updates an existing one.
Action
Write
Create or Update Company
Creates a new company or updates an existing one.
Action
Write
Create Expense
Creates a new expense.
Action
Write
Create or Update Invoice
Creates a new invoice or updates an existing one.
Action
Write
Create or Update Person
Creates a new person or updates an existing one if e-mail address of the person match.
Action
Write
- Project
  Required
- Comment text
  Required
Action
Write
Create or Update Purchase Order
Creates a new purchase order or updates an existing one.
Action
Write
- Invoice
  Required
- Receipt account
- Receipt sum
  Required
- Receipt date
Action
Write
- Task
  Required
- Comment text
  Required
Action
Write
- Task ID
  Required
- Completed datetime
Action
Write
- Task
  Required
- Start datetime
- Duration
- Is billable
- Description
- Activity type
- Is completed
Action
Write
- Company name
  Required
Action
Search
- Invoice number
  Required
Action
Search
Find Person
Find person by full name, email or ID.
Action
Search
- Purchase order number
  Required
Action
Search
- Custom field name
  Required
- Custom field value
  Required
Action
Search
- User Email
  Required
Action
Search

- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Condition Type
  Required
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to Copy
  Required
- Worksheet to Copy
  Required
- Copy Worksheet Destination
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Confirm Deletion
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Format Type
  Required
Action
Write
- Spreadsheet
  Required
- Worksheet
  Required
- New Sheet Name
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Sort by Column
  Required
- Sort Order
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- A1 Range
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row ID
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write
New Bill
Triggers when a new bill is created.
Trigger
Instant
Try It
New Calendar Event
Triggers when a new calendar event is created.
Trigger
Instant
Try It
New Company
Triggers when a new company is created.
Trigger
Instant
Try It
New or Updated Expense
Triggers when an expense is created or modified.
Trigger
Instant
Try It
New Invoice
Triggers when a new invoice is created.
Trigger
Instant
Try It
New Order
Triggers when a new order is created.
Trigger
Instant
Try It
New Person
Triggers when a new person is created.
Trigger
Instant
Try It
New Project
Triggers when a new project is created.
Trigger
Instant
Try It
New Purchase Order
Triggers when a new purchase order is created.
Trigger
Instant
Try It
New Quote
Triggers when a new quote is created.
Trigger
Instant
Try It
New Task
Triggers when a new task is created.
Trigger
Instant
Try It
Create Calendar Event
Creates a new calendar event.
Action
Write
Create or Update Custom Entry
Creates a new custom entry or updates an existing one.
Action
Write
- Document ID
  Required
- Document Type
  Required
Action
Write
Create or Update Order
Creates a new order or updates an existing one.
Action
Write
- Project
  Required
- File
  Required
- File name
Action
Write
Create or Update Project
Creates a new project or updates an existing one.
Action
Write
Create or Update Quote
Creates a new quote or updates an existing one.
Action
Write
- Task
  Required
- File
  Required
- File name
Action
Write
- Task ID
- Task name
- Task description
- Task start datetime
- Task due datetime
- Planned duration
- Task status
- Task priority
- Is personal event
- Company name
- Person name
- Project name
- Activity type
- Responsible user
- Assignee(s)
- File
Action
Write
Update Task Under a Project
Updates a specific task under a project.
Action
Write
- Bill number
  Required
- Issuer ID
  Required
Action
Search
- Custom module
  Required
- Custom field name
  Required
- Custom field value
  Required
Action
Search
- Order number
  Required
Action
Search
- Name
- Number
Action
Search
- Quote number
  Required
Action
Search
- Project ID
  Required
- Task name
  Required
Action
Search

About Google Sheets

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

Learn moreLearn moreHelpHelp

Related categories

Google

Spreadsheets

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

About Scoro

Scoro is a comprehensive work management software – an all-in-one solution to track your time, manage projects and bill for your work

Learn moreLearn moreHelpHelp

Related categories

Project Management

Related Zap Templates

Manage new Scoro invoices by creating spreadsheets in Google Sheets