Alegra + Google Sheets + Gmail Integrations
How to connect Alegra + Google Sheets + Gmail
Zapier lets you send info between Alegra and Google Sheets and Gmail automatically—no code required. With 7,000+ supported apps, the possibilities are endless.
Choose a Trigger
Start here
Start here
Choose an Action
Choose an Action
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Alegra + Google Sheets + Gmail
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Alegra, Google Sheets, and Gmail. And don’t forget that you can add more apps and actions to create complex workflows.
New Contact
Triggers when a new contact is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Invoice
Triggers when a new invoice is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNombre (Name)Required
Tipo de contacto (Contact type)
Tipo (type)Required
Número (number)Required
Número telefónico principal (phonePrimary)
Número telefónico secundario (phoneSecondary)
Fax
Número de célular/móvil (mobile)
Observaciones (observations)
Correo electrónico (email)
Dirección (address)Required
Provincia (province)Required
Ciudad (city)Required
Código postal (postalCode)Required
Verificar identificación no registrada (ignoreRepeated)
Condición del IVA (ivaCondition)Required
Incluir enlace del estado de cuenta del cliente (statementAttached)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Nombre (Name)Required
Tipo de contacto (Contact type)
Tipo (type)Required
Número (number)Required
Número telefónico principal (phonePrimary)
Número telefónico secundario (phoneSecondary)
Fax
Número de célular/móvil (mobile)
Observaciones (observations)
Correo electrónico (email)
Dirección (address)
Provincia (department)
Cantón (city)
Distrito (district)
Barrio (neighborhood)
Verificar identificación no registrada (ignoreRepeated)
Incluir enlace del estado de cuenta del cliente (statementAttached)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Tipo de contactoRequired
Tipo de terceroRequired
Tipo de personaRequired
Teléfono principal
Teléfono secundario
Teléfono móvil
Correo
Fax
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Nombre (Name)Required
Número de identificación (Identification)
Tipo de contacto (Contact type)
Número telefónico principal (Phone primary)
Número telefónico secundario (Phone secondary)
Fax
Número de célular/móvil (Mobile)
Observaciones (observations)
Correo electrónico (Email)
Dirección (address)
Ciudad (city)
Verificar identificación no registrada (Ignore repeated)
Incluir enlace del estado de cuenta del cliente (statementAttached)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Fecha (Date) (YYYY-MM-DD)Required
Observaciones (Observations)
Almacén (Warehouse)Required
Centro de costo (Cost center)
ÍtemRequired
Tipo (Type)Required
Costo Unitario (Unit Cost)Required
Cantidad (Quantity)Required
ID de Resolución (Resolution ID)
Prefijo de numeración (Numbering Prefix)
Numeración (Numbering)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Fecha (date)Required
Fecha de vencimiento (dueDate)Required
Observaciones (observations)
Comentarios (anotation)
Estado (status)
Numeración de la factura (Invoice numeration)
Cliente ID (client)Required
items IDRequired
Precios (price)Required
Cantidad (quantity)Required
Descuentos (discount)
Referencia (Reference)
Descripción (description)
Bodega / Almacén (Warehouse)
Vendedor (Seller)
Centro de costos (Cost center)
Código de la moneda (Currency code)
Tasa de cambio (Exchange rate)
Tipo de Factura (Invoice type)
Forma de pago (paymentForm)
Emitir la factura (generateStamp)Required
Actividad económica (economicActivity)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Fecha (date)Required
Fecha de vencimiento (dueDate)Required
Observaciones (observations)
Comentarios (anotation)
Estado (status)Required
Numeración de la factura (Invoice numeration)
Cliente ID (client)Required
items IDRequired
Precios (price)Required
Cantidad (quantity)Required
Descuentos (discount)
Impuesto (tax)
Naturaleza del descuento (discount nature)
Referencia (reference)
Descripción (description)
Bodega / Almacén (Warehouse)
Vendedor (Seller)
Centro de costos (Cost center)
Código de la moneda (Currency code)
Tasa de cambio (Exchange rate)
Tipo de Factura (Invoice type)
Método de pago (paymentMethod)Required
Emitir la factura (generateStamp)
Condición de la venta (saleCondition)
Actividad económica (economicActivity)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Emitir factura electrónicaRequired
Tipo
Numeración de la factura
ClienteRequired
IDRequired
PrecioRequired
Referencia
Descripción
Impuesto
CantidadRequired
Vendedor
FechaRequired
Fecha de vencimientoRequired
Notas
Observaciones
Moneda
Tipo de cambio
Almacén
Centro de costos
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Fecha (date)Required
Fecha de vencimiento (dueDate)Required
Observaciones (observations)
Comentarios (anotation)
Estado (status)
Numeración de la factura (Invoice numeration)
Tipo de Operación (Operation type)
Cliente ID (client)Required
items IDRequired
Precios (price)Required
Cantidad (quantity)Required
Descuentos (discount)
Impuesto (tax)
Referencia (Reference)
Descripción (description)
Bodega / Almacén (Warehouse)
Vendedor (Seller)
Centro de costos (Cost center)
Código de la moneda (Currency code)
Tasa de cambio (Exchange rate)
Emitir la factura (generateStamp)Required
Método de Pago (Payment Method)Required
Cuotas Info
Periodicidad (periodicity)
Número de Cuotas (numberQuotas)
Información sobre las cuotas (quotas info)
Montos de las cuotas(amount)
Fecha de vencimiento de las cuotas (quotas due date)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Nombre (Name)Required
Descripción (Description)
Precio (Price)Required
Partida arancelaria (tariffHeading)
Categoría del ítem (Item Category)
Impuesto (Tax)
Tipo (type)
Código de producto (Product Key)
ID del producto (Item Id)
Cantidad (Quantity)
Unidad (unit)
Costo unitario (Unit cost)
Cantidad inicial (Initial quantity)
Tipo (type)
Referencia (reference)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Nombre del producto (Name)Required
Descripción (Description)
Precio (Price)Required
Referencia (Reference)
Categoría del ítem (Item Category)
Impuesto (Tax)
Tipo (Type)
ID del producto (Item Id)
Cantidad (Quantity)
Unidad (unit)
Costo unitario (Unit cost)
Cantidad inicial (Initial quantity)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Fecha (Date)Required
Fecha De Vencimiento (dueDate)Required
Cliente ID (Client ID)Required
Items IDRequired
Precios (price)Required
Impuesto (Tax)Required
Cantidad (Quantity)Required
Descuentos (Discount)Required
Bodega/Almacén (Warehouse)
Observaciones (Observations)
Nota de la remisión (Anotation)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID de la Factura (Invoice Id)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Id de la cotización (Estimate ID)Required
Destinatatio (To):Required
Enviarme copia (Send Copy to Myself)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID del contacto (Contact ID)Required
Primer Nombre (firstName)
Apellidos (LastName)
Número telefónico principal (phonePrimary)
Tipo de persona (kindOfPerson)
Tipo de contacto (Contact type)
Tipo (type)
Número (number)
Dirección (address)
Municipio (City)
Departamento (department)
País (country)
Código postal (zip code)
Correo electrónico (email)
Régimen (regime)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID del ítem (Item Id)Required
Nombre del producto (Name)
Descripción (Description)
Precio (Price)
Referencia (Reference)
Categoría del ítem (Item Category)
Impuesto (Tax)
Unidad (unit)
Costo unitario (Unit cost)
Cantidad inicial (Initial quantity)
Estatus (Status)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contacto a buscar (Contact to find)Required
ActionThis is an event a Zap performs.SearchFind existing data in your appContacto a buscar (Contact to find)Required
ActionThis is an event a Zap performs.SearchFind existing data in your appContacto a buscar (Contact to find)Required
ActionThis is an event a Zap performs.SearchFind existing data in your appContacto a buscar (Contact to find)Required
ActionThis is an event a Zap performs.SearchFind existing data in your appNombre del ítem (Item name)Required
ActionThis is an event a Zap performs.SearchFind existing data in your appNombre del ítem (Item name)Required
ActionThis is an event a Zap performs.SearchFind existing data in your appContacto a buscar (Contact to find)Required
Nombre (Name)Required
Tipo de contacto (Contact type)
Tipo (type)Required
Número (number)Required
Número telefónico principal (phonePrimary)
Número telefónico secundario (phoneSecondary)
Fax
Número de célular/móvil (mobile)
Observaciones (observations)
Correo electrónico (email)
Dirección (address)Required
Provincia (province)Required
Ciudad (city)Required
Código postal (postalCode)Required
Verificar identificación no registrada (ignoreRepeated)
Condición del IVA (ivaCondition)Required
Incluir enlace del estado de cuenta del cliente (statementAttached)
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundContacto a buscar (Contact to find)Required
Primer Nombre (firstName)Required
Apellidos (LastName)
Número telefónico principal (phonePrimary)
Tipo de persona (kindOfPerson)Required
Tipo de contacto (Contact type)
Tipo (type)Required
Número (number)Required
Número telefónico secundario (phoneSecondary)
Dirección (address)
Municipio (City)
Departamento (department)
País (country)
Código postal (zip code)
fax
Número de celular/móvil (mobile)
Observaciones (observations)
Correo electrónico (email)
Verificar identificación no registrada (ignoreRepeated)
Régimen (regime)
Incluir enlace del estado de cuenta del cliente (statementAttached)
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundContacto a buscar (Contact to find)Required
Nombre (Name)Required
Tipo de contacto (Contact type)
RFC (identification)Required
Tipo de Tercero (Third type)
Identificador fiscal (Fiscal ID)
Calle (street)
Número de exterior (exteriorNumber)
Número de interior (interiorNumber)
Colonia (Colony)
País (country)
Localidad (locality)
Municipio (municipality)
Estado (state)Required
Código postal (zipCode)
Número telefónico principal (phonePrimary)
Número telefónico secundario (phoneSecondary)
Fax
Número de célular/móvil (mobile)
Observaciones (observations)
Correo electrónico (email)
Verificar identificación no registrada (ignoreRepeated)
clave del Uso CFDI (cfdiUse)
Forma de pago (paymentMethod)
Método de pago (paymentType)
Incluir enlace del estado de cuenta del cliente (statementAttached)
Regímenes Fiscales
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundContacto a buscar (Contact to find)Required
Nombre (Name)Required
Tipo de contacto (Contact type)
Tipo (type)Required
Número (number)Required
Número telefónico principal (phonePrimary)
Número telefónico secundario (phoneSecondary)
Fax
Número de célular/móvil (mobile)
Observaciones (observations)
Correo electrónico (email)
Dirección (address)
Departamento (state)
Provincia (city)
Urbanización (urbanization)
Distrito (district)
Código ubigeo (ubigeoCode)
Verificar identificación no registrada (ignoreRepeated)
Incluir enlace del estado de cuenta del cliente (statementAttached)
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNombre del ítem (Item name)Required
Nombre (Name)Required
Descripción (Description)
Precio (Price)Required
Partida arancelaria (tariffHeading)
Categoría del ítem (Item Category)
Impuesto (Tax)
Tipo (type)
Código de producto (Product Key)
ID del producto (Item Id)
Cantidad (Quantity)
Unidad (unit)
Costo unitario (Unit cost)
Cantidad inicial (Initial quantity)
Tipo (type)
Referencia (reference)
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNombre del ítem (Item name)Required
Nombre del producto (Name)Required
Descripción (Description)
Precio (Price)Required
Referencia (Reference)
Categoría del ítem (Item Category)
Impuesto (Tax)
Tipo (Type)
ID del producto (Item Id)
Cantidad (Quantity)
Unidad (unit)
Costo unitario (Unit cost)
Cantidad inicial (Initial quantity)
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo 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.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
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
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 Label
Triggers when you add a new label.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Starred Email
Triggers when you receive a new email and star it within two days.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planLabel
MessageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Recipient Instructions
To
Cc
Bcc
SubjectRequired
From
From Name
Body type
BodyRequired
Add signature default
Label or mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name of labelRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.MessageRequired
Label(s) to removeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search StringRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
New Estimate
Triggers when a new estimate is created in Alegra.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Item
Triggers when a new product or service is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNombre (Name)Required
Tipo de contacto (Contact type)
Identificación (Identification)Required
Número telefónico principal (phonePrimary)
Número telefónico secundario (phoneSecondary)
Fax
Número de célular/móvil (mobile)
Observaciones (observations)
Correo electrónico (email)
Ciudad (city)
Región (region)
Comuna (commune)
Descripción (description)
Verificar identificación no registrada (ignoreRepeated)
Incluir enlace del estado de cuenta del cliente (statementAttached)
Giro de negocio (giro)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Nombre (Name)Required
Tipo de contacto (Contact type)
RFC (identification)Required
Tipo de Tercero (Third type)
Identificador fiscal (Fiscal ID)
Calle (street)
Número de exterior (exteriorNumber)
Número de interior (interiorNumber)
Colonia (Colony)
País (country)
Localidad (locality)
Municipio (municipality)
Estado (state)Required
Código postal (zipCode)
Número telefónico principal (phonePrimary)
Número telefónico secundario (phoneSecondary)
Fax
Número de célular/móvil (mobile)
Observaciones (observations)
Correo electrónico (email)
Verificar identificación no registrada (ignoreRepeated)
clave del Uso CFDI (cfdiUse)
Forma de pago (paymentMethod)
Método de pago (paymentType)
Incluir enlace del estado de cuenta del cliente (statementAttached)
Regímenes Fiscales
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Nombre (Name)Required
Tipo de contacto (Contact type)
Tipo (type)Required
Número (number)Required
Número telefónico principal (phonePrimary)
Número telefónico secundario (phoneSecondary)
Fax
Número de célular/móvil (mobile)
Observaciones (observations)
Correo electrónico (email)
Dirección (address)
Departamento (state)
Provincia (city)
Urbanización (urbanization)
Distrito (district)
Código ubigeo (ubigeoCode)
Verificar identificación no registrada (ignoreRepeated)
Incluir enlace del estado de cuenta del cliente (statementAttached)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Fecha (Date)Required
Fecha de vencimiento (Due Date)Required
Observaciones (Observations)
Comentarios (Anotation)
ID del Cliente (Client ID)Required
Items IDRequired
Precios (price)Required
Cantidad (quantity)Required
Descuentos (discount)
Impuesto (tax)
Referencia (Reference)
Descripción (description)
Vendedor (Seller)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Fecha (date)Required
Fecha de vencimiento (dueDate)Required
Observaciones (observations)
Comentarios (anotation)
Estado (status)
Numeración de la factura (Invoice numeration)
Cliente ID (client)Required
items IDRequired
Precios (price)Required
Cantidad (quantity)Required
Descuentos (discount)
Impuesto (tax)
Referencia (Reference)
Descripción (description)
Bodega / Almacén (Warehouse)
Vendedor (Seller)
Centro de costos (Cost center)
Código de la moneda (Currency code)
Tasa de cambio (Exchange rate)
Emitir la factura (generateStamp)
Condición de la venta (saleCondition)
Concepto de venta (saleConcept)
Fecha de inicio (startDateService)
Fecha final (endDateService)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Fecha (date)Required
Fecha de vencimiento (dueDate)Required
Observaciones (observations)
Comentarios (anotation)
Estado (status)
Numeración de la factura (Invoice numeration)
Cliente ID (client)Required
Items IDRequired
Precios (price)Required
Cantidad (quantity)Required
Descuentos (discount)
Impuesto (tax)
Referencia (Reference)
Descripción (description)
Bodega / Almacén (Warehouse)
Vendedor (Seller)
Centro de costos (Cost center)
Código de la moneda (Currency code)
Tasa de cambio (Exchange rate)
Tipo de Factura (Invoice type)
Forma de pago (paymentForm)Required
Método de pago (paymentMethod)
Emitir la factura (generateStamp)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Fecha (date)Required
Fecha de vencimiento (dueDate)Required
Observaciones (observations)
Comentarios (anotation)
Estado (status)
Numeración de la factura (Invoice numeration)
Cliente ID (client)Required
items IDRequired
Precios (price)Required
Cantidad (quantity)Required
Descuentos (discount)
Impuesto (tax)
Referencia (Reference)
Descripción (description)
Pedimento (importRequest)
Bodega / Almacén (Warehouse)
Vendedor (Seller)
Centro de costos (Cost center)
Código de la moneda (Currency code)
Tasa de cambio (Exchange rate)
Tipo de Factura (Invoice type)
Forma de pago (paymentMethod)Required
Método de la factura (paymentType)
Clave del Uso CFDI (cfdiUse)Required
Timbrar la factura (generateStamp)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Fecha (Date)Required
Cuenta de Banco (Bank Account)Required
Método de pago (Payment Method)
Cliente/Proveedor (Client)
Tipo de Pago (Type of payment)
Tipo de transacción (Type of Transaction)Required
Id de la factura (Invoice Id)
Monto del pago (Payment Amount)
Id de la cuenta contable (Category id)
Valor (Price)
Código de la moneda (Currency code)
Tasa de cambio (Exchange rate)
Observaciones (Observations)
Notas (Anotation)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Fecha (date)Required
Fecha De Vencimiento (dueDate)Required
Observaciones (observations)
Comentarios (anotation)
Estado (status)
Cliente ID (Client ID)Required
Numeración de la factura (Invoice numeration)
Items IDRequired
Precios (price)Required
Cantidad (quantity)Required
Descuentos (discount)
Impuesto (tax)
Referencia (Reference)
Descripción (description)
Bodega / Almacén (Warehouse)
Tipo de Factura (Invoice type)
Vendedor (Seller)
Centro de costos (Cost center)
Código de la moneda (Currency code)
Tasa de cambio (Exchange rate)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Nombre (Name)Required
Descripción (Description)
Precio (Price)Required
Referencia (Reference)
Número de la clave de producto (ProductKey)Required
Categoría del ítem (Item Category)
Impuesto (Tax)
Tipo (type)
ID del producto (Item Id)
Cantidad (Quantity)
Unidad (unit)
Costo unitario (unitCost)
Cantidad inicial (Initial quantity)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Fecha (date)Required
Fecha de vencimiento (dueDate)Required
Observaciones (observations)
Términos y Condiciones (Terms and Conditions)
Numeración de la factura (Invoice numeration)
Proveedor (provider)Required
Bodega / Almacén (Warehouse)
Código de la moneda (Currency code)
Tasa de cambio (Exchange rate)
Detalle (Details)
Items ID
Precios (price)
Cantidad (quantity)
Descuentos (discount)
Impuesto (tax)
Observaciones (observations)
Categorías ID
Precios (price)
Cantidad (quantity)
Descuentos (discount)
Impuesto (tax)
Observaciones (observations)
Id Retención (retention ID)
Monto Retención (retention amount)
Fecha (date)
Cuenta (account)
Monto (amount)
Método de pago (Payment Method)
Notas (anotations)
Observaciones (observations)
Id Retenciones (retentions ID)
Monto Retención (retention Amount)
Código de la moneda (Currency code)
Tasa de cambio (Exchange rate)
Centro de costos (Cost center)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Nombre (Name)Required
Procentaje (Percentage)Required
Tipo (Type)Required
Descripción (Description)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Primer Nombre (firstName)Required
Apellidos (LastName)
Número telefónico principal (phonePrimary)
Tipo de persona (kindOfPerson)Required
Tipo de contacto (Contact type)
Tipo (type)Required
Número (number)Required
Número telefónico secundario (phoneSecondary)
Dirección (address)
Municipio (City)
Departamento (department)
País (country)
Código postal (zip code)
fax
Número de celular/móvil (mobile)
Observaciones (observations)
Correo electrónico (email)
Verificar identificación no registrada (ignoreRepeated)
Régimen (regime)
Incluir enlace del estado de cuenta del cliente (statementAttached)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID de la factura (Invoice ID)Required
Tipo de Factura (Invoice Type)
Destinatario (To)Required
Enviarme copia (Send Copy to Myself)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID del contacto (Contact ID)Required
Tipo de contacto (Contact type)
Nombre (Name)
Número de identificación (Identification Number)
Correo electrónico (Email)
Número de teléfono principal (Primary Phone Number)
Número de teléfono secundario (Secondary Phone Number)
Fax
Número De Celular/móvil (Mobile)
Observaciones (Observations)
Dirección (Address)
Ciudad (City)
Calle (Street)
Número exterior (Exterior Number)
Número interior (Interior Number)
Colonia (Colony)
Localidad (Locality)
Municipio (Municipality)
Estado (State)
País (Country)
Código Postal (Zip Code)
Id de Vendedor Asociado (Associate Seller ID)
Lista de Precios (Price List)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contacto a buscar (Contact to find)Required
ActionThis is an event a Zap performs.SearchFind existing data in your appContacto a buscar (Contact to find)Required
ActionThis is an event a Zap performs.SearchFind existing data in your appContacto a buscar (Contact to find)Required
ActionThis is an event a Zap performs.SearchFind existing data in your appContacto a buscar (Contact to find)Required
ActionThis is an event a Zap performs.SearchFind existing data in your appNombres de los items (Items names)Required
ActionThis is an event a Zap performs.SearchFind existing data in your appNombre del ítem (Item name)Required
ActionThis is an event a Zap performs.SearchFind existing data in your appImpuesto (tax)Required
ActionThis is an event a Zap performs.SearchFind existing data in your appContacto a buscar (Contact to find)Required
Nombre (Name)Required
Tipo de contacto (Contact type)
Identificación (Identification)Required
Número telefónico principal (phonePrimary)
Número telefónico secundario (phoneSecondary)
Fax
Número de célular/móvil (mobile)
Observaciones (observations)
Correo electrónico (email)
Ciudad (city)
Región (region)
Comuna (commune)
Descripción (description)
Verificar identificación no registrada (ignoreRepeated)
Incluir enlace del estado de cuenta del cliente (statementAttached)
Giro de negocio (giro)
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundContacto a buscar (Contact to find)Required
Nombre (Name)Required
Tipo de contacto (Contact type)
Tipo (type)Required
Número (number)Required
Número telefónico principal (phonePrimary)
Número telefónico secundario (phoneSecondary)
Fax
Número de célular/móvil (mobile)
Observaciones (observations)
Correo electrónico (email)
Dirección (address)
Provincia (department)
Cantón (city)
Distrito (district)
Barrio (neighborhood)
Verificar identificación no registrada (ignoreRepeated)
Incluir enlace del estado de cuenta del cliente (statementAttached)
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundContacto a buscar (Contact to find)Required
Tipo de contactoRequired
Tipo de terceroRequired
Tipo de personaRequired
Teléfono principal
Teléfono secundario
Teléfono móvil
Correo
Fax
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundContacto a buscar (Contact to find)Required
Nombre (Name)Required
Número de identificación (Identification)
Tipo de contacto (Contact type)
Número telefónico principal (Phone primary)
Número telefónico secundario (Phone secondary)
Fax
Número de célular/móvil (Mobile)
Observaciones (observations)
Correo electrónico (Email)
Dirección (address)
Ciudad (city)
Verificar identificación no registrada (Ignore repeated)
Incluir enlace del estado de cuenta del cliente (statementAttached)
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNombre del ítem (Item name)Required
Nombre (Name)Required
Descripción (Description)
Precio (Price)Required
Referencia (Reference)
Número de la clave de producto (ProductKey)Required
Categoría del ítem (Item Category)
Impuesto (Tax)
Tipo (type)
ID del producto (Item Id)
Cantidad (Quantity)
Unidad (unit)
Costo unitario (unitCost)
Cantidad inicial (Initial quantity)
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundImpuesto (tax)Required
Nombre (Name)Required
Procentaje (Percentage)Required
Tipo (Type)Required
Descripción (Description)
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
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
Headers
Overwrite existing worksheets
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
Text Bold
Text Italic
Text Strikethrough
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
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundLabel or mailbox
Search keywords
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planEmail message to be DeletedRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Trigger Instructions
ThreadRequired
To
Cc
Bcc
From
From Name
Body type
BodyRequired
Add signature default
Label or mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.To
Cc
Bcc
From
From Name
Reply To
SubjectRequired
Body type
BodyRequired
Add signature default
Label or mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Trigger Instructions
ThreadRequired
To
Cc
Bcc
From
From Name
Reply To
Body type
BodyRequired
Label or mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search StringRequired
To
Cc
Bcc
From
From Name
Reply To
SubjectRequired
Body type
BodyRequired
Add signature default
Label or mailbox
Attachments
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
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How Alegra + Google Sheets + Gmail Integrations Work
- Step 1: Authenticate Alegra, Google Sheets, and Gmail.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
Related categories
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
About Gmail
One of the most popular email services, Gmail keeps track of all your emails with threaded conversations, tags, and Google-powered search to find any message you need.
Other Alegra + Google Sheets Integrations
Other Google Sheets + Gmail Integrations
- google-drive
- typeform
- trello
- schedule
- code
- mailchimp
- linkedin-lead-gen-forms
- google-calendar
- google-docs
- webflow
- facebook-lead-ads-beta
- gravity-forms
- hubspot
- airtable
- pipedrive
- unbounce
- email-parser
- google-lead-form-extension
- calendly
- asana
- salesforce
- activecampaign
- twilio
- sms
- stripe
- squarespace
- jotform
- manychat
- google-slides
- leadpages
- perspective
- zapier-chrome-extension
- surveymonkey
- shopify
- wufoo
- mysql
- leadconnector
- wix-automations
- instapage
- streak
- dropbox
- google-ads
- acuity-scheduling
- clicksend
- google-contacts
- digest
- keap-max-classic
- cognito-forms
- leadformly
- quickbooks
- xero
- wpforms
- paypal
- clickup
- chatwork
- callrail
- woocommerce
- surveygizmo
- convertkit
- zoho-crm
- thinkific
- ninjaforms
- groovefunnels
- wordpress
- thrivecart
- landbot
- kartra
- kajabi
- zoom
- mailerlite
- notion
- glide-apps
- zendesk
- webinarjam
- getresponse
- sendinblue
- instamojo
- candidatezip
- paperform
- monday
- jira-software
- pdfmonkey
- pandadoc
- copper
- adalo
- netlify
- url-shortener
- teachable
- pdffiller
- formstack
- 123formbuilder
- zoho-forms
- postgresql
- responder
- textmagic
- sql-server
- rss
- facebook-pages
- eventbrite
- basecamp3
- ringcentral
- facebook-messenger
- todoist
- discord
- process-street
- leadshook
- excel
- closeio
- google-my-business
- podio
- outgrow
- mailparser
- landingi
- formsite
- zapier-manager
- tidio
- signrequest
- powr-form-builder
- ontraport
- klaviyo
- clio
- square
- pdfco
- lead-information
- firebase
- constant-contact
- optinmonster
- translate
- signnow
- onedrive
- mobilemonkey
- intercom
- google-tasks
- google-cloud-print
- google-chat
- campaign-monitor
- aweber
- approval
- agile-crm
- chatfuel
- scheduleonce
- rd-station
- mailshake
- lemlist
- involveme
- gumroad
- freshdesk
- formidable
- follow-up-boss
- easycsv
- docusign
- cliengo
- chargebee
- autopilot
- trinsic
- swipe-pages
- solapi
- simpletexting
- poptin
- patreon
- nocrm-io
- microsoft-outlook
- highrise
- gotowebinar
- google-analytics
- facebook-custom-audiences
- evernote
- drip
- docparser
- bitly
- basin
- bark
- box
- paykickstart
- zoho-subscriptions
- woodpecker
- wisepops
- videoask
- sumo
- sierra-interactive
- parseur
- meistertask
- maskyoo-call-events
- learndash
- inforumobile
- htmlcss-to-image
- heymarket
- harvest
- facebook-groups
- bloomerang
- amazon-seller-central
- gocanvas
- liondesk-crm
- kvcore
- invoice-ninja
- zipwhip
- wishpond
- vimeo
- thrive-themes
- textlocal
- tally
- systeme
- sub-zap-by-zapier
- splash
- snovio
- smoove
- short-io
- shipstation
- sharpspring
- servicem8
- podia
- mautic
- leadquizzes3
- kissflow
- jira
- google-bigquery
- formstack-documents
- formsapp
- flodesk
- ecwid
- ebay
- duda
- dubsado
- demio
- contacts-plus
- burner
- bucketio
- boomtown
- better-proposals
- bannerbear
- whatconverts
- chatterpal
- wunderlist
- wistia
- weather
- waiverforever
- sendpulse
- sendgrid
- safetyculture
- redtailcrm
- rebrandly
- real-geeks
- quotient
- quickemailverification
- onenote
- officeguy
- moskit
- mailjet
- looping
- kwcommand
- jira-service-desk
- hover
- crove
- chirply
- activecollab
- linear
- zoho-sign
- youtube
- wrike
- wispform
- wine-ambassador
- wati
- vbout
- upviral
- upcall
- umso
- trainerize
- tilda-publishing
- the-receptionist
- textit
- teamwork
- surveysparrow
- super-forms
- strava
- storage
- stealthseminar
- smtp
- smsapi
- smashleads
- smartsheet
- slybroadcast
- setmore-appointment
- sendmsg
- samcart
- salesmsg
- salesflare
- revolut-for-business
- quiz-maker
- quickbase
- qr-code-generator-1
- proposify
- printful
- practice-ignition
- pipefy
- phone-com
- phantombuster
- pep-cloud
- peltarion
- odoo
- nimble
- nethunt-crm
- nanonets-ocr
- mongodb
- mojo
- mightynetworks
- microsoft-todo
- memberspace
- memberful
- marketo
- mandrill
- magento
- learnworlds
- leadquizzes
- knack
- joonbot
- instagram-lead-ads
- insightly
- infobip
- influencersoft
- hello-bar
- google-groups
- google-assistant
- glow
- glip
- gevme-virtual
- getform
- gatherup
- funnelcockpit
- front-app
- flg
- feedier
- delighted
- coopel
- cloudconvert
- cinc
- chime
- bytesview
- burst-sms
- bubble
- braintree
- boleto-simples
- beeliked
- basecamp2
- azure-devops
- avochato
- appointy
- anymail-finder
- amocrm
- amazon-sns
- activetrail
- act-on
- woobox
- viral-loops
- filevine
- zulip
- zoomai
- zoho-sheet
- zoho-recruit
- zoho-desk
- zoho-creator
- zoho-books
- zipperagent
- zillow
- zenvia
- zenler
- zendesk-sell
- zapier
- zakeke-product-customizer
- ytel
- youengage
- youcanbookme
- ws-form
- wp-website-creator
- wp-all-export-pro
- wordsmith
- woodpecker-2
- wodify
- winsms
- whatsapp-business-api
- weforms
- weezevent
- webinarkit
- wealthbox
- wave
- walcu-crm
- vidyard
- vanillasoft
- uptics
- unisender
- typebot
- twist
- trevor
- trackvia
- tookan
- tokko-broker
- timify
- timetonic
- timekit
- tiktok-lead-generation
- tick
- things
- thankster
- textline
- textedly
- text-request
- text-in-church
- teamwave
- teamleader
- talentlms
- surveybot
- survey-funnel
- survey-anyplace
- surefire
- super-receptionist
- sunrise
- submittable
- street-text
- stannp
- stamplate
- sproutvideo
- spotify
- spark-hire
- sotechnocrats
- solve360
- sms-alert
- slicktext
- sleekflow
- skipio
- skedda
- sirena
- shortcut
- shopvox
- shop-ware
- sharetribe-flex
- sendy
- sendowl
- sendloop
- sendhub
- sendfox
- sellercloud
- seamless-ai
- scoro
- samepage
- salsa-engage
- salesrabbit
- salesmate
- sakari-sms
- ryver
- rocketchat
- rise
- revv-documents
- revue
- respond-flow
- repsly
- reply
- regfox
- redmine
- recruitcrm
- razorpay-1
- quora-lead-gen-forms
- quickmail
- quickbooks-commerce
- questionscout
- qualtrics
- qonto
- pushover
- pure-chat
- pro-lead
- privyr
- privy
- printavo
- prefinery
- powerisa-speed
- plumsail-documents
- planso
- planbox-agile-central
- placester
- pipeliner
- phonewagon
- phoneburner
- philips-hue
- perfit
- pendo
- paystack
- paypro
- payhere
- pathwright
- pardot
- openphone
- onepage
- onelocal-localreferrals
- on24
- olark
- ohmylead
- office-365
- nudgify
- nifty-pm
- neverbounce
- naturalforms
- nationbuilder
- myvr
- myphoner
- mrpeasy
- more-trees
- moonclerk
- monkeylearn
- monetizze
- mondaycom
- mollie-1
- mobimag
- mobile-text-alerts
- mindee-ocr
- microsoft-teams
- mews
- metatask
- messagebird
- mention
- meisterplan
- maximizer
- marketsharp
- mailgun
- lodgify-requested
- livestorm
- livechat
- linkwizard
- linked-helper
- lightspeed-vt
- learnybox-d
- leadsquared
- leadpops
- leadowl
- leadfeeder
- leaddyno
- lark
- klick-tipp
- kizen
- kixie
- kintone
- kickofflabs
- karmacrm
- jobber
- iterable
- ip2location
- interact
- instagram-for-business
- instabot
- imap
- ihomefinder
- hunter
- humanitix
- housecall-pro
- hotjar
- hopin
- honeybook
- hnry
- heysummit
- heyspace
- help-scout
- heights-platform
- hailer
- gymsales
- growth-x
- growsurf
- groove
- greenrope
- greenhouse
- gosquared
- goproposal
- google-meet
- glitterly
- givingfuel
- gitlab
- github
- gist
- giphy
- ghost
- getsitecontrol
- getaccept
- freshworks-crm
- freshbooks
- formtitan
- formly
- force24
- flutterwave
- flock
- firepoint-crm
- filesdotcom
- favro
- facebook-offline-conversions
- ezeep-blue
- eventzilla
- esponce
- esignaturesio
- epos-now
- encharge
- emma
- elasticemail
- easytranslate
- e-goi
- drove
- dropfunnels
- dropcontact
- dotloop
- docupilot
- digimember
- dialog-messenger
- deputy
- deltanet-crm
- deepcrawl
- dealmachine
- databox
- dagger-for-ethereum
- cyfe
- credit-repair-cloud
- cozycal
- coupon-carrier
- convertflow
- convertcalculator
- convertapi
- contractbook
- contactually
- confluence-cloud
- collect-chat
- coda
- cloudtalk
- clockify
- clicksign
- clickmeeting
- click
- clearbit
- circle
- chili-piper
- checkfront
- chatfuel-for-facebook
- chatbot
- chargify
- ceipal
- cassa-in-cloud
- capsulecrm
- capsule-crm
- callhub
- callfire
- bulksmscom
- buildfire
- bucketio-2
- brushfire
- bright-sites
- brewsurvey-qa
- bombbombcom
- bmby-crm
- bl-ink
- bizzabo
- birdeye
- bind-erp
- bigml
- bigcartel
- bexio
- benchmarkone
- benchmark-email
- beepsend
- beaconstac
- base
- bamboohr
- azendoo
- axonaut
- avanser
- automizy
- autoklose
- assignar
- artibotai
- approval-donkey
- appointlet
- apifonica
- anywhereworks
- any-do
- anedot
- amazon-s3
- amazon-polly
- amazon-honeycode
- amazon-fba
- allmysms
- agentology
- affinity
- affiliatewp
- advertising-bait
- acumbamail
- actionstep
- acerill-custom-forms
- accredible
- academyocean
- abyssale
- 46elks
- teamsupport
- formkeep