Skip to content
  • Morningstar AdviserLogic logoMorningstar AdviserLogic logo
  • Google Sheets logoGoogle Sheets logo

Morningstar AdviserLogic + Google Sheets

Add entities to AdviserLogic from new or updated Google Sheets rows

Instead of wasting time manually transferring entities from a spreadsheet, use this Zapier automation. Once set up, whenever you update or add a new row to a Google Sheets spreadsheet, Zapier will automatically create or update an entity in AdviserLogic automatically.

Instead of wasting time manually transferring entities from a spreadsheet, use this Zapier automation. Once set up, whenever you update or add a new row to a Google Sheets spreadsheet, Zapier will automatically create or update an entity in AdviserLogic automatically.

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

    Triggers when a new row is added or modified in a spreadsheet.

    TriggerInstant
  2. automatically do this!
    Morningstar AdviserLogicMorningstar AdviserLogic
    Create or Update Entity

    Updates the existing entity, otherwise creates a new entity.

    ActionWrite
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Polling
    Try It
    • No Team Drive

    • SpreadsheetRequired

    • WorksheetRequired

    • Trigger column

    Trigger
    Instant
    Try It
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    • Column NameRequired

    • Index

    Action
    Write
    • No Team Drive

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Instant
    Try It
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    • Trigger column

    Trigger
    Polling
    Try It
    • Drive

    • SpreadsheetRequired

    Trigger
    Polling
    Try It
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    • Use Timezone set up on the spreadsheet to format date values?

    Action
    Write
adviserlogic logo
adviserlogic logo

About Morningstar AdviserLogic

Morningstar AdviserLogic is a financial planning and business management solution that positions advisers to engage and impress clients while efficiently running their business and helping them meet compliance obligations.
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.

Related categories

Triggers & Actions