Google Sheets + AdviserLogic Fact Finder

Google Sheets + AdviserLogic Fact Finder integrations

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.

When this happens...
New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstant
automatically do this!
Client Basic Information Add/Edit Basic information of client in AdviserLogic Application
ActionWrite

Start free with email

Start free with Google

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

More things you can do with Google Sheets and AdviserLogic Fact Finder

Discover other triggers and actions you can use with Google Sheets and AdviserLogic Fact Finder

- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Column_name
  Required
- Index
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write

- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Source Range
  Required
- Destination Range
  Required
- Paste Type
Action
Write

- Drive
- Title
  Required
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Validation Type
  Required
- Input Message
- Strict Validation
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Columns
  Required
- Row count
  Required
- Output format
- First row
Action
Search
- Spreadsheet ID
  Required
- Include Grid Data
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
- adlClientID
  Required
Trigger
Polling
Try It
- adlClientID
  Required
Trigger
Polling
Try It
- adlClientID
  Required
Trigger
Polling
Try It
- adlClientID
  Required
Trigger
Polling
Try It
- adlClientID
  Required
Trigger
Polling
Try It
- ADL ClientID
  Required
- dependantID
- id
- First Name
- Last Name
- Relation Type
- Date of Birth
- To Age
- Notes
Action
Write
- 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
Action
Write
- adlClientID
  Required
- 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
Action
Write
- 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
Action
Write
- Adlclient ID
  Required
- 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
Action
Write
- 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
Action
Write
- adlClientID
- Category
- Sub Category
- Description
- Amount
- Frequency
- Recipient
- Taxable
- Exclude From Age Pension
- Payment Type
Action
Write

- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Condition Type
  Required
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to Copy
  Required
- Worksheet to Copy
  Required
- Copy Worksheet Destination
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Confirm Deletion
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Format Type
  Required
Action
Write
- Spreadsheet
  Required
- Worksheet
  Required
- New Sheet Name
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Sort by Column
  Required
- Sort Order
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- A1 Range
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row ID
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write
- adlClientID
  Required
Trigger
Polling
Try It
- adlClientID
Trigger
Polling
Try It
- adlClientID
  Required
Trigger
Polling
Try It
Get Client Basic Information
Get Basic Information of client saved under AdviserLogic application
Trigger
Polling
Try It
- External ID
  Required
- 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
Action
Write
- 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
Action
Write
- adlClientID
  Required
- 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
Action
Write
- 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
Action
Write
- adlClientID
  Required
- 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
Action
Write
- 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
Action
Write
- 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
Action
Write

About Google Sheets

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

Learn moreLearn moreHelpHelp

Related categories

Google

Spreadsheets

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

About AdviserLogic Fact Finder

Fact Finder is an application to either fetch, create, or update Fact Finder data as per current AdviserLogic schema

HelpHelp

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Forms

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier