Morningstar AdviserLogic + Google Sheets

Add new AdviserLogic Entity details to Google Sheets

Want to make your life a bit easier? Use Zapier to do the admin work of copying entities for you. Once you set up this AdviserLogic-Google Sheets integration, whenever you add a new entity, it'll automatically be added in Google Sheets.

When this happens...
New or Updated Client
Triggers when a client is created or updated.
TriggerPolling
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Supported triggers and actions

New or Updated Client
Triggers when a client is created or updated.
Trigger
Polling
Try It
- External ID
- Subject
- Description
- StartDate
- EndDate
- Attendees
- Location
- Invitee Response
- Invitee Type
- Event Importance
- Event Visibility
- Event Status
- Event Organizer
- IsAllday
- Recurrence-DaysOfWeek
- Recurrence-FirstDayOfWeek
- Recurrence-Interval
- Recurrence-Type
- Recurrence-DayOfMonth
- Recurrence-Index
- Recurrence-Month
- Recurrence-NumberOfOccurences
- Recurrence-TimeZone
- Recurrence-StartDate
- Recurrence-EndDate
- Recurrence-RangeType
Action
Write
- First NameRequired
- Last NameRequired
- Date of BirthRequired
- GenderRequired
- External IDRequired
- Client ID
- Full Name
- Occupation
- Client Start Date
- Job Title
- Notes
- Phone (Home)
- Phone (Mobile)
- Phone (Work)
- Fax
- Email (Home)
- Email (Work)
- Address (Line 1)
- Address (Line 2)
- Address (Suburb)
- Address (PostCode)
- Address (Country)
- Address (State)
- Facebook
- Skype
- LinkedIn
- Twitter
- Source
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It

- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write

- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write

New Diary Event
Triggers when a new event is added to your diary. Only triggers for events in the next 2 months.
Trigger
Polling
Try It
- External ID
- Subject
- Description
- StartDate
- EndDate
- Attendees
- Location
- Invitee Response
- Invitee Type
- Event Visibility
- Event Status
- Event Organizer
Action
Write
- External IDRequired
- Entity IDRequired
- SourceRequired
- Record ID
- Parent ID
- Company Name
- TFN
- Acn
- Abn
- Notes
- Corporate Trustee
- Entity TypeRequired
- Member ID
- Trustee Name
- Trustee
- Director
- Share Percentage
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
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
Action
Search or write

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.