Google Sheets + AdviserLogic Fact Finder
Create new AdviserLogic Fact Finder clients from new or updated Google Sheets rows
Keep your client information up-to-date and organized with this workflow that connects Google Sheets to AdviserLogic Fact Finder. Whenever there's a new or updated row in your Google Sheets spreadsheet, this automation will streamline the process by adding or updating the client's basic information in AdviserLogic Fact Finder. Say goodbye to manual data entry and enjoy a more efficient way of managing your client information.
Keep your client information up-to-date and organized with this workflow that connects Google Sheets to AdviserLogic Fact Finder. Whenever there's a new or updated row in your Google Sheets spreadsheet, this automation will streamline the process by adding or updating the client's basic information in AdviserLogic Fact Finder. Say goodbye to manual data entry and enjoy a more efficient way of managing your client information.
- When this happens...
New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Client Basic InformationAdd/Edit Basic information of client in AdviserLogic Application
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No 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.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundADL ClientIDRequired
dependantID
id
First Name
Last Name
Relation Type
Date of Birth
To Age
Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.adlClientID
Expense ID
Category
SubCategory
Type
Description
Amount
Frequency
Payer
Taxability
Expense Start Type
Expense Start Date
Expense Start Age
Expense End Type
Expense End Date
Expense End Age
No Of Payments
No Of Years
Growth
Growth Rate
Superfund
Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.adlClientIDRequired
Category
Sub Category
Description
Amount
Frequency
Recipient
Taxable
Exclude From Age Pension
Payment Type
Index Rate
Apply Deeming Rates
Annuity Balance
Ncc Component
Annual Pension
Business
Status
Income Start
Income Start Date
Income Start Age
Income End
Income End Date
Income End Age
Growth
Notes
Employer
SGC
Superfund
Balance Date
Growth Rate
Asset Test
Deductible Amount
Number of Payments
Number of Years
Rate of Return
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.adlClientID
Superfund Id
Superfund Type
Name
Member
Account Number
Account Status
Platform
Industry Superfund Name
Issue Date
Estate Option
Death Nominee
Commencement Date
Account Code
ABN
Member ID
Member Name
Balance Percentage
Member Estate Option
Member Death Nominee
Member Bdn Expiry Date
Other Name
Bdn Expiry Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Adlclient IDRequired
Client Phone Home
Client Phone Mobile
Client Phone Work
Client Email Work
Client Email Home
Client Fax
Client Home Address Line 1
Client Home Address Line 2
Client Home Address Suburb
Client Home Address State
Client Home Address Postcode
Client Home Address Country
Client Mailing Address Line1
Client Mailing Address Line2
Client Mailing Address Suburb
Client Mailing Address State
Client Mailing Address Postcode
Client Mailing Address Country
Client Work Address Line 1
Client Work Address Line 2
Client Work Address Suburb
Client Work Address State
Client Work Address Postcode
Client Work Address Country
Client Other Address Line 1
Client Other Address Line 2
Client Other Address Suburb
Client Other Address State
Client Other Address PostCode
Client Other Address Country
Partner Contact Phone Home
Partner Contact Phone Mobile
Partner Contact Phone Work
Partner Contact Email Work
Partner Contact Fax
Partner Home Address Line 1
Partner Home Address Line 2
Partner Home Address Suburb
Partner Home Address State
Partner Home Address PostCode
Partner Home Address Country
Partner Mailing Address Line 1
Partner Mailing Address Line 2
Partner Mailing Address Suburb
Partner Mailing Address State
Partner Mailing Address PostCode
Partner Mailing Address Country
Partner Work Address Line 1
Partner Work Address Line 2
Partner Work Address Suburb
Partner Work Address State
Partner Work Address PostCode
Partner Work Address Country
Partner Other Address Line 1
Partner Other Address Line 2
Partner Other Address Suburb
Partner Other Address State
Partner Other Address PostCode
Partner Other Address Country
Client Preferred Email Address
Client Preferred Contact Address
Client Preferred Phone Number
Client Preferred Contact Method
Client Australian Resident
Client Do Not Contact
Client Subscribed To Newsletter
Client Send MailCO
Client Send Birthday SMS
Client Notes
Partner Notes
Partner Preferred Email Address
Partner Preferred Contact Address
Partner Preferred Phone Number
Partner Preferred Contact Method
Partner Australian Resident
Partner Do Not Contact
Partner Subscribed To Newsletter
Partner Send MailCO
Partner Send Birthday SMS
Client Social Network Facebook
Client Social Network Skype
Client Social Network LinkedIn
Client Social Network Twitter
Client Social Network Website
Client Social Network DropBox Link
Partner Social Network Facebook
Partner Social Network Skype
Partner Social Network LinkedIn
Partner Social Network Twitter
Partner Social Network Website
Dropbox Hyperlink
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client Phone - Home
Client Phone - Mobile
Client Phone - Work
Client Email Work
Client Email Home
Client Fax
Client Home Address Line 1
Client Home Address Line 2
Client Home Address Suburb
Client Home Address State
Client Home Address Postcode
Client Home Address Country
Client Mailing Address Line1
Client Mailing Address Line2
Client Mailing Address Suburb
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.adlClientID
Category
Sub Category
Description
Amount
Frequency
Recipient
Taxable
Exclude From Age Pension
Payment Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Row count
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
Row count
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
Get Client Basic Information
Get Basic Information of client saved under AdviserLogic application
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planExternal IDRequired
Client Title
Client First Name
Client Middle Name
Client Surname
Client Preferred Name
Client Date of Birth
Client Gender
Client Occupation
Client Driver License
Client Marital Status
Client Centrelink Number
Client Place Of Birth
Client Job Title
Client Employment Status
Adviser
Last Review Date
Next Review Date
Category
Review Frequency
Wedding Date
Last Contact Date
Last SOA Date
Client Service Manager
Adviser Group
ReferredBy
Status
Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.adlClientID
Entity ID
Name
ABN
ACN
Notes
Base Rate Company
Corptrustee
Entity Type
Entity Detail Id
Entity Name
Othername
Share Percentage
Is Trustee
Is Director
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.adlClientIDRequired
healthInfoID
Client Smoker
Client Health Status
Client Health Insurance
Client Weight
Client Height
Client Existing Medical Issues
Client Physical Ailments
Client Claim Insurance
Client Family Medical Issues
Partner healthInfoID
Partner Health Status
Partner Smoker
Partner Health Insurance Type
Partner Weight
Partner Height
Partner Existing Medical Issues
Partner Physical Ailments Issues
Partner claim Insurance Issues
Partner Family Medical Issues
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.adlClientID
Insurance Id
Insurer
Description
Other Insurer Name
Status
Cover ID
Insurance Type
Sum Insured
Monthly Benefit
Owner
Premium
Premium Frequency
Other Owner Name
Policy Number
Life Insured
Policy Purpose
Total Premium
Policy Premium Frequency
Policy Fee
Stampduty
Beneficiary ID
Beneficiary Name
Relationship
Beneficiary Percentage
Other Beneficiary Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.adlClientIDRequired
Partner Title
Partner First Name
Partner Middle Name
Partner Surname
Partner Preferred Name
Partner Date of Birth
Partner Gender
Partner Occupation
Partner Driver License
Partner Marital Status
Partner Centrelink Number
Partner Place Of Birth
Partner Job Title
Partner Employment Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.External ID
Title
First Name
Middle Name
Surname
Preferred Name
Date Of Birth
Gender
Occupation
Driver License
Marital Status
Centrelink Number
Place Of Birth
Job Title
Employment Status
Adviser
lastReviewDate
nextReviewDate
Category
Review Frequency
Wedding Date
Last Contact Date
Last SOA Date
Client Service Manager
Adviser Group
Notes
ReferredBy
Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.adlClientID
Expense ID
Category
SubCategory
Type
Description
Amount
Frequency
Payer
Taxability
Expense Start Type
Expense Start Date
Expense Start Age
Expense End Type
Expense End Date
Expense End Age
No Of Payments
No Of Years
Growth
Growth Rate
Superfund
Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
About Google Sheets
Related categories
