Contele Gestor de Equipes + Google Sheets

Create spreadsheet rows in Google Sheets for new places in Contele Gestor de Equipes

Create a streamlined, efficient workflow with Contele Gestor de Equipes and Google Sheets. When a new place is added in Contele Gestor de Equipes, a corresponding row is instantaneously generated in Google Sheets, saving you time and reducing potential errors. Tailored specifically for your convenience, this automation enhances your data management by ensuring your spreadsheets are constantly updated in real-time.

When this happens...
Place Created
Triggers when a new place 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?

Form Answered
Triggers when a form is answered for the first time.
Trigger
Instant
Try It
Place Created
Triggers when a new place is created.
Trigger
Instant
Try It
Visit Checked In
Triggers when a visit has been checked in.
Trigger
Instant
Try It
Visit Created
Triggers when a new visit is created.
Trigger
Instant
Try It
- Portfolios
- Place nameRequired
- Place document
- Place corporate name
- Place observation
- Place address city
- Place address complement
- Place address neighborhood
- Place address number
- Place address state
- Place address street
- Place address zipcode
- Place address latitude
- Place address longitude
- Contact name
- Contact email
- Contact phone
- Category name
- Custom id (your id)
- Creator ID
- Creator Email
Action
Write

- Unique task identificator (task_id or Service Order)Required
- Schedule date (yyyy-mm-dd hh:mm)
- Consider scheduling time?
- Details
- Observation
- Custom OS
- Status
Action
Write
- 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
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search or write

Form Answered When Completed V2
Triggers when a form is answered.
Trigger
Instant
Try It
Place Updated
Triggers when a place is updated.
Trigger
Instant
Try It
Visit Checked Out
Triggers when a visit has been checked out.
Trigger
Instant
Try It
Visit Updated
Triggers when a visit is updated.
Trigger
Instant
Try It
- Schedule date (yyyy-mm-dd hh:mm)Required
- Consider scheduling time?
- Details
- Observation
- Custom OS
- User Creator ID
Action
Write
- Unique place identificator (poi_id OR custom_id OR cnpj)Required
- Place name
- Place document
- Place corporate name
- Place observation
- Place address city
- Place address complement
- Place address neighborhood
- Place address number
- Place address state
- Place address street
- Place address zipcode
- Place address latitude
- Place address longitude
- Contact name
- Contact email
- Contact phone
- Category name
- Custom id (your id)
- Portfolios
Action
Write
- 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 Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
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
- Search from last row
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Search or write

About Contele Gestor de Equipes

Contele Gestor de Equipes is an app for any type of field team manager for companies with Check-in/out, Routing, Checklists, Forms, Refund register, Tracking, Digital Service Order, Plan and Scheduler visits and reports.

Help

Related categories

Team Collaboration

About Google Sheets

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

Learn more Help

Contele Gestor de Equipes + Google Sheets

Create spreadsheet rows in Google Sheets for new places in Contele Gestor de Equipes

Form Answered

Place Created

Visit Checked In

Visit Created

Create Place

Portfolios

Place document

Place corporate name

Place observation

Place address city

Place address complement

Place address neighborhood

Place address number

Place address state

Place address street

Place address zipcode

Place address latitude

Place address longitude

Contact name

Contact email

Contact phone

Category name

Custom id (your id)

Creator ID

Creator Email

Update Visit

Schedule date (yyyy-mm-dd hh:mm)

Consider scheduling time?

Details

Observation

Custom OS

Status

New Spreadsheet Row (Team Drive)

Drive

New Spreadsheet

Drive

New or Updated Spreadsheet Row

No Team Drive

Trigger Column

Create Spreadsheet Column

Drive

Index

Create Multiple Spreadsheet Rows

Drive

Create Spreadsheet

Spreadsheet to Copy

Headers

Clear Spreadsheet Row

Drive

Update Spreadsheet Row

Drive

API Request (Beta)

Api Docs Info

Query String Parameters

Headers

Additional Request Headers

Body

Find Worksheet

Drive

Lookup Spreadsheet Row

Drive

Supporting Lookup Column

Supporting Lookup Value

Search from last row

Find or Create Row

Drive

Supporting Lookup Column

Supporting Lookup Value

Search from last row

Form Answered When Completed V2

Place Updated

Visit Checked Out

Visit Updated

Schedule Visit

Consider scheduling time?

Details

Observation

Custom OS