Loading

Alegra + Google Sheets

Create Alegra invoices from new Google Sheets rows

Make sure your invoice info ends up where it needs to, and make it easy by automating. With this integration, whenever a new Google Sheets row is added, a corresponding Alegra invoice will be created automatically. Lose the busy work and focus on the things that matter, like getting more sales!

Make sure your invoice info ends up where it needs to, and make it easy by automating. With this integration, whenever a new Google Sheets row is added, a corresponding Alegra invoice will be created automatically. Lose the busy work and focus on the things that matter, like getting more sales!

  1. When this happens...
    Google SheetsGoogle Sheets
    New Spreadsheet Row

    Triggered when a new row is added to the bottom of a spreadsheet.

    TriggerInstant
  2. automatically do this!
    AlegraAlegra
    Create Invoice

    Crear una nueva factura de venta. Create a new invoice.

    ActionWrite
Try this template
Free 14-day trial
5,000+ supported apps

Supported triggers and actions

What does this mean?
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    • SpreadsheetRequired

    • WorksheetRequired

      You must have column headers

    Trigger
    Scheduled
    Try It
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    Trigger
    Scheduled
    Try It
    • No Team Drive

      If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.

    • SpreadsheetRequired

    • WorksheetRequired

      You must have column headers

    • Trigger Column

      Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.

    Trigger
    Instant
    Try It
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    • SpreadsheetRequired

    • WorksheetRequired

    • Column NameRequired

    • Index

      The column position (zero-based) to insert. If not set, append to the right by default.

    Action
    Write
    • No Team Drive

      If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.

    • SpreadsheetRequired

    • WorksheetRequired

      You must have column headers

    Trigger
    Instant
    Try It
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    • SpreadsheetRequired

    • WorksheetRequired

      You must have column headers

    • Trigger Column

      Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.

    Trigger
    Scheduled
    Try It
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    • SpreadsheetRequired

    Trigger
    Scheduled
    Try It
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    • SpreadsheetRequired

    • WorksheetRequired

    Action
    Write