Google Sheets + MOCO

Create MOCO projects from new or updated rows in Google Sheets

When changes occur in your Google Sheets, now they can have an immediate impact on your MOCO projects. With this workflow, each time a new row is added or updated in your spreadsheets, it prompts the creation of a new project in MOCO. That means your projects stay fresh and relevant, aligning seamlessly with your latest data - all in real-time. Get ready for improved efficiency as this integration seamlessly bridges your spreadsheet data with your project management.

When this happens...
New or Updated Spreadsheet Row
Triggered when a new row is added or modified in a spreadsheet.
TriggerInstant
automatically do this!
Create Project
Creates a new Project.
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?

- 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
New Time Entry
Triggers when a new time entry is created.
Trigger
Instant
Try It
New Company
Triggers when a new company is created.
Trigger
Instant
Try It
New Client
Triggers when a new client is created.
Trigger
Instant
Try It
New Expense
Triggers when an expense is created.
Trigger
Instant
Try It
New Invoice
Triggers when a new invoice is created.
Trigger
Instant
Try It
New Incoming Payment
Triggers when a new incoming payment is created.
Trigger
Instant
Try It
New Offer
Triggers when a new offer is created.
Trigger
Instant
Try It
New Presence
Triggers when a new Presence is created.
Trigger
Instant
Try It
New Project Assignment
Triggers when a person is assigned to a project.
Trigger
Instant
Try It
New Purchase
Triggers when a new purchase is created.
Trigger
Instant
Try It
New Recurred Expense
Triggers when an expense is recurred.
Trigger
Instant
Try It
New Task
Triggers when a new task is created.
Trigger
Instant
Try It
Archived Project
Triggers when a project is archived.
Trigger
Instant
Try It
Updated Time Entry
Triggers when a time entry was updated.
Trigger
Instant
Try It
Updated Contact Person
Triggers when a contact person was updated.
Trigger
Instant
Try It
Updated Expense
Triggers when an expense was updated.
Trigger
Instant
Try It
Updated Offer
Triggers when an offer was updated.
Trigger
Instant
Try It
Updated Presence
Triggers when a Presence was updated.
Trigger
Instant
Try It
Updated Purchase
Triggers when a purchase was updated.
Trigger
Instant
Try It
- UserRequired
- ProjectRequired
- DateRequired
- DescriptionRequired
- Task NameRequired
- Tag
- SecondsRequired
Action
Write
- Gender
- First NameRequired
- Last NameRequired
- Title
- Mobile Phone
- Work Phone
- Work Fax
- Work Email
- Work Address
- Home Email
- Home Address
- Birthday
- Company
Action
Write
- ProjectRequired
- TitleRequired
- Description
- DateRequired
- QuantityRequired
- UnitRequired
- Unit PriceRequired
- Unit CostRequired
- BillableRequired
- Included in Budget?Required
- File
Action
Write
- NameRequired
- AmountRequired
- CurrencyRequired
- Reminder DateRequired
- Info
- Responsible
- Company
- Stage
- Contact
Action
Write
- SupplierRequired
- CreatorRequired
- File
- DateRequired
- Due Date
- Service Period From
- Service Period To
- Invoice number
- CurrencyRequired
- Payment MethodRequired
- Info
- TitleRequired
- TotalRequired
- Tax (%)Required
- Tax included in Total?Required
- Category
Action
Write
- Task NameRequired
- Project IdentifierRequired
- Hourly Rate
- Task Budget
- Active
- Billable
Action
Write
- ID
- Date
- ProjectRequired
- UserRequired
Action
Search
- ID
- Firstname
- Lastname
- Work Email
- Phone Number
- Company Name
Action
Search
- ID
- Title
- ProjectRequired
Action
Search
- ID
- Identifier
Action
Search
- ID
- Identifier
- Company Name
- Name
Action
Search
- ID
- Name
- Credit Account
Action
Search
- ID
- Last Name
- First 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
Approved Holiday Request
Triggers when a holiday request is approved.
Trigger
Instant
Try It
New Comment
Triggers when a new comment is created.
Trigger
Instant
Try It
New Contact Person
Triggers when a new contact person is created.
Trigger
Instant
Try It
New Lead
Triggers when a new lead was created.
Trigger
Instant
Try It
New Holiday Request
Triggers when a new holiday request is created.
Trigger
Instant
Try It
New Exported Invoice (Bookkeeping)
Triggers when a new invoice is exported (for the bookkeeping).
Trigger
Instant
Try It
New Invoice Status
Triggers when the status of an invoice is changed.
Trigger
Instant
Try It
New Planning Entry
Triggers when a new Planning Entry is created.
Trigger
Instant
Try It
New Project
Triggers when a new project is created.
Trigger
Instant
Try It
New Project Budget Alert
Triggers when a project budget alert event has happened.
Trigger
Instant
Try It
New Outgoing Payment
Triggers when a new outgoing payment is created.
Trigger
Instant
Try It
New Sales Activity
Triggers when a new sales activity has happened.
Trigger
Instant
Try It
New User
Triggers when a new User is created.
Trigger
Instant
Try It
Unarchived Project
Triggers when a project is made active again.
Trigger
Instant
Try It
Updated Company
Triggers when a company was updated.
Trigger
Instant
Try It
Updated Lead
Triggers when a lead was updated.
Trigger
Instant
Try It
Updated Invoice
Triggers when an invoice was updated.
Trigger
Instant
Try It
Updated Planning Entry
Triggers when a Planning Entry was updated.
Trigger
Instant
Try It
Updated Project
Triggers when a project was updated.
Trigger
Instant
Try It
Updated User
Triggers when a User was updated.
Trigger
Instant
Try It
- TargetRequired
- MessageRequired
- User
Action
Write
- NameRequired
- Identifier
- CurrencyRequired
- UserRequired
- Fax
- Email
- Phone
- Address
- Vat
- Website
- Info
- Country Code
Action
Write
- Invoice
- TotalRequired
- DateRequired
- CurrencyRequired
- Partial payment?
- Transaction Identifier
Action
Write
- CompanyRequired
- Identifier
- NameRequired
- CurrencyRequired
- Billing ByRequired
- Hourly Rate
- Budget
- Budget Expenses
- LeaderRequired
- Finish Date
- Info
- Fixed price?
Action
Write
- Purchase
- DateRequired
- TotalRequired
- CurrencyRequired
- Description
- Transaction Identifier
Action
Write
- UserRequired
Action
Write
- ID
- Identifier
- Name
- Type
Action
Search
- ID
- Name
- Status
- Contact Work Email
- Company Name
Action
Search
- ID
- Identifier
Action
Search
- ID
- Date
- ProjectRequired
- UserRequired
Action
Search
- ID
- Identifier
- Receipt Identifier
Action
Search
- ID
- ProjectRequired
- Task NameRequired
Action
Search

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 MOCO

MOCO (MObile COmpany) is a lean cloud software made for small medium-sized agency and service businesses. Including time tracking, billing, resource planning, sales-funnel and CRM.

Learn more Help

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Interfaces

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

PRODUCTS

CAPABILITIES

By team

Google Sheets + MOCO

Create MOCO projects from new or updated rows in Google Sheets

New Spreadsheet Row (Team Drive)

Drive

WorksheetRequired

New Spreadsheet

Drive

New or Updated Spreadsheet Row

No Team Drive

SpreadsheetRequired

WorksheetRequired

Trigger Column

Create Spreadsheet Column

Drive

SpreadsheetRequired

WorksheetRequired

Column NameRequired

Index

Create Multiple Spreadsheet Rows

Drive

SpreadsheetRequired

WorksheetRequired

Create Spreadsheet

TitleRequired

Spreadsheet to Copy

Headers

Delete Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

RowRequired

Update Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

RowRequired

API Request (Beta)

Api Docs Info

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

Find Worksheet

Drive

SpreadsheetRequired

TitleRequired

Lookup Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

Lookup ColumnRequired

Lookup ValueRequired

Supporting Lookup Column

Supporting Lookup Value

Bottom-Up

Find or Create Row

Drive

SpreadsheetRequired

WorksheetRequired

Lookup ColumnRequired

Lookup ValueRequired

Supporting Lookup Column

Supporting Lookup Value

Bottom-Up

New Time Entry

New Company

New Client

New Expense

New Invoice

New Incoming Payment

New Offer

New Presence

New Project Assignment

New Purchase

New Recurred Expense