Alegra + Google Sheets

Create multiple rows in Google Sheets when new contacts appear in Alegra

Keep your Google Sheets updated with the latest contacts from your Alegra app with this intuitive workflow. As new contacts are added in Alegra, this automation will instantly create multiple rows in your selected Google Sheets file for each contact. This helps maintain an updated and organized record of all your contacts in a familiar spreadsheet format, in real-time.

Keep your Google Sheets updated with the latest contacts from your Alegra app with this intuitive workflow. As new contacts are added in Alegra, this automation will instantly create multiple rows in your selected Google Sheets file for each contact. This helps maintain an updated and organized record of all your contacts in a familiar spreadsheet format, in real-time.

  1. When this happens...
    AlegraAlegra
    New Contact

    Triggers when a new contact is created.

    TriggerScheduled
  2. automatically do this!
    Google SheetsGoogle Sheets
    Create Multiple Spreadsheet Rows

    Create one or more new rows in a specific spreadsheet (with line item support).

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

  • Alegra triggers, actions, and search

    New Contact

    Triggers when a new contact is created.

    Trigger
    Scheduled
    Try It
  • Alegra triggers, actions, and search

    New Invoice

    Triggers when a new invoice is created.

    Trigger
    Scheduled
    Try It
    • 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)

    Action
    Write
    • 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)

    Action
    Write
  • Alegra triggers, actions, and search

    New Estimate

    Triggers when a new estimate is created in Alegra.

    Trigger
    Scheduled
    Try It
  • Alegra triggers, actions, and search

    New Item

    Triggers when a new product or service is created.

    Trigger
    Scheduled
    Try It
    • 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)

    Action
    Write
    • 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

    Action
    Write
alegra logo
alegra logo

About Alegra

Alegra is an accounting and billing app designed for Latin American managers.

Related categories

  • Accounting
google-sheets logo
google-sheets logo

About Google Sheets

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

Related categories

  • Google
  • Spreadsheets

Similar apps

Zapier Tables integrationsZapier Tables integrations

Zapier Tables

Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets