Agendor + Google Sheets
Create or update Agendor organizations from new Google Sheets rows
Keep your Agendor organization database up to date with this seamless workflow. Whenever a new row is added to your Google Sheets spreadsheet, this automation will create or update the corresponding organization in Agendor. Stay organized and save time by consolidating information from spreadsheets directly into your CRM.
Keep your Agendor organization database up to date with this seamless workflow. Whenever a new row is added to your Google Sheets spreadsheet, this automation will create or update the corresponding organization in Agendor. Stay organized and save time by consolidating information from spreadsheets directly into your CRM.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create or Update OrganizationCreates or updates an Organization (Empresa).
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Task
Triggers when a new Task (Tarefa/Comentário) is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deal Lost
Triggers when a Deal (Negócio) is set as lost.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Deal
Triggers when a Deal (Negócio) is edited.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Organization
Triggers when a new Organization (Empresa) is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Person
Triggers when a new Person (Pessoa) is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Relates to (Relaciona-se a)Required
Text (Texto)Required
Author (Criador)Required
Due Date (Data de Agendamento)
Assigned Users (Usuários Responsáveis)
Finished? (Finalizada?)
Metrics (Métricas)
Type (Tipo)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DealRequired
Deal Status (Status do Negócio)Required
End Time (Data de Conclusão)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Name (Nome)
Legal Name (Razão Social)
CNPJ
Description (Descrição)
Website
Ranking
Owner User (Usuário Responsável)
Email
Work Phone (Telefone de Trabalho)
Mobile Phone (Telefone Celular)
Fax Phone
WhatsApp
Facebook
Twitter
Instagram
LinkedIn
Skype
Postal Code (CEP)
Country (País)
State (Estado)
City (Cidade)
District (Bairro)
Street (Rua)
Additional Address Info (Complemento)
Category (Categoria)
Sector (Setor)
Products (Produtos)
Lead Origin (Origem do Cliente)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PersonRequired
Name (Nome)Required
Role (Cargo)
CPF
Ranking
Description (Descrição)
Birthday (Aniversário)
Owner User (Usuário Responsável)
Organization (Empresa)
Category (Categoria)
Products (Produtos)
Lead Origin (Origem do Cliente)
Author (Criador)
Email
Work Phone (Telefone de Trabalho)
Mobile Phone (Telefone Celular)
Fax Phone
WhatsApp
Facebook
Twitter
Instagram
LinkedIn
Skype
Postal Code (CEP)
Country (País)
State (Estado)
City (Cidade)
District (Bairro)
Street (Rua)
Additional Address Info (Complemento)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Cnpj
Email
ActionThis is an event a Zap performs.SearchFind existing data in your appTitle (Título)Required
Organization (Empresa)
Person (Pessoa)
Deal Status (Status do Negócio)
Description (Descrição)
Products (Produtos)
Ranking
Start Time (Data de Início)
End Time (Data de Conclusão)
Owner User (Usuário Responsável)
Funnel (Funil)
Value (Valor)
Author (Criador)
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundName (Nome)Required
CPF
Email
Role (Cargo)
Ranking
Description (Descrição)
Birthday (Aniversário)
Owner User (Usuário Responsável)
Organization (Empresa)
Category (Categoria)
Products (Produtos)
Lead Origin (Origem do Cliente)
Author (Criador)
Work Phone (Telefone de Trabalho)
Mobile Phone (Telefone Celular)
Fax Phone
WhatsApp
Facebook
Twitter
Instagram
LinkedIn
Skype
Postal Code (CEP)
Country (País)
State (Estado)
City (Cidade)
District (Bairro)
Street (Rua)
Additional Address Info (Complemento)
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Deal
Triggers when a new Deal (Negócio) is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deal Stage Changed
Triggers when a Deal (Negócio) moves to another stage (Etapa) in the pipeline.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deal Won
Triggers when a Deal (Negócio) is set as won.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Organization
Triggers when an Organization (Empresa) is edited.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Person
Triggers when a Person (Pessoa) is edited.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DealRequired
Funnel (Funil)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DealRequired
Value (Valor)
Description (Descrição)
Start Time (Data de Início)
Products (Produtos)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name (Nome)Required
Legal Name (Razão Social)
CNPJ
Description (Descrição)
Website
Ranking
Owner User (Usuário Responsável)
Email
Work Phone (Telefone de Trabalho)
Mobile Phone (Telefone Celular)
Fax Phone
WhatsApp
Facebook
Twitter
Instagram
LinkedIn
Skype
Postal Code (CEP)
Country (País)
State (Estado)
City (Cidade)
District (Bairro)
Street (Rua)
Additional Address Info (Complemento)
Category (Categoria)
Sector (Setor)
Products (Produtos)
Lead Origin (Origem do Cliente)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name (Nome)Required
EmailRequired
Role (Cargo)
CPF
Ranking
Description (Descrição)
Birthday (Aniversário)
Owner User (Usuário Responsável)
Organization (Empresa)
Category (Categoria)
Products (Produtos)
Lead Origin (Origem do Cliente)
Author (Criador)
Work Phone (Telefone de Trabalho)
Mobile Phone (Telefone Celular)
Fax Phone
WhatsApp
Facebook
Twitter
Instagram
LinkedIn
Skype
Postal Code (CEP)
Country (País)
State (Estado)
City (Cidade)
District (Bairro)
Street (Rua)
Additional Address Info (Complemento)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Title (Título)
Organization (Empresa)
Person
ActionThis is an event a Zap performs.SearchFind existing data in your appName
Cpf
Email
ActionThis is an event a Zap performs.SearchFind existing data in your appName (Nome)Required
CNPJ
Email
Legal Name (Razão Social)
Description (Descrição)
Website
Ranking
Owner User (Usuário Responsável)
Work Phone (Telefone de Trabalho)
Mobile Phone (Telefone Celular)
Fax Phone
WhatsApp
Facebook
Twitter
Instagram
LinkedIn
Skype
Postal Code (CEP)
Country (País)
State (Estado)
City (Cidade)
District (Bairro)
Street (Rua)
Additional Address Info (Complemento)
Category (Categoria)
Sector (Setor)
Products (Produtos)
Lead Origin (Origem do Cliente)
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Agendor
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Log new lost Agendor deals as rows in Google Sheets
- Create new Google Sheets rows for Agendor deals as they happen
- Add new Agendor organizations to Google Sheets rows instantly
- Create Google Sheets rows for new won deals in Agendor
- Create Google Sheets rows for updated Agendor deal stages
- Create or update Agendor persons when new rows are added in Google Sheets
- Create or update Agendor persons when new or updated rows come in Google Sheets
- Create or update Agendor organizations from new or updated rows in Google Sheets
- Update Google Sheets rows with new tasks from Agendor
- Create spreadsheet rows in Google Sheets for new tasks in Agendor