AgencyBloc + Google Sheets
Create new individuals in AgencyBloc from new rows in Google Sheets
When a new row appears in your Google Sheets, this workflow instantly creates an individual in your AgencyBloc system. Save time on manual data entry and ensure prompt updates in your contact management tool. Benefit from a seamless data transfer process, enhancing your productivity and focus on more important tasks.
When a new row appears in your Google Sheets, this workflow instantly creates an individual in your AgencyBloc system. Save time on manual data entry and ensure prompt updates in your contact management tool. Benefit from a seamless data transfer process, enhancing your productivity and focus on more important tasks.
- When this happens...
New Spreadsheet RowTriggered when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create IndividualCreates an Individual in AgencyBloc.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo 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.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
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
Bottom-Up
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
Activity Updated
Triggers when an Activity is updated in AgencyBloc.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Group Updated
Triggers when a Group is updated in AgencyBloc.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Mask SSN Data
Mask Medicare Beneficiary ID Data
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Policy Updated
Triggers when a Policy is updated in AgencyBloc.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Create Groups Description
Group NameRequired
DBA
Description
Federal Tax ID
Industry - SIC ID
Industry - SIC Description
Industry - ID
Employee Count
Website
Group Type - Text
Group Type - ID
Group Status - Text
Group Status - ID
Account Manager - ID
Servicing Agent - First name
Servicing Agent - Last Name
Servicing Agent - Middle Name
Servicing Agent - ID
Additional Agent 1 - First Name
Additional Agent 1 - Last Name
Additional Agent 1 - Middle Name
Additional Agent 1 - ID
Additional Agent 2 - First Name
Additional Agent 2 - Last Name
Additional Agent 2 - Middle Name
Additional Agent 2 - ID
Additional Agent 3 - First Name
Additional Agent 3 - Last Name
Additional Agent 3 - Middle Name
Additional Agent 3 - ID
Business Phone Number
Business Phone Number Ext.
Fax Number
Fax Number Ext.
Address Type
Is Primary Address
Address Street 1
Address Street 2
City
County
State/Province
Zip Code
Lead Date
Lead Source - Text
Lead Source - ID
Other Lead Source
Lead Agent/Affiliate - First Name
Lead Agent/Affiliate - Last Name
Lead Agent/Affiliate - Middle Name
Lead Agent/Affiliate - ID
Project Code - Text
Project Code - ID
Group Custom Fields Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Policies Description
Policyholder TypeRequired
Policyholder - ID
Carrier - Name
Carrier - ID
Policy Number
Premium
Lives
Pay Frequency
Project Code - Text
Project Code - ID
Status - Text
Status - ID
Coverage Type - Text
Coverage Type - ID
App Submit Date
Effective Date
Renewal Date
Term Date
Signed By - First Name
Signed By - Last Name
Signed By - Middle Name
Signed By - ID
Account Manager - First Name
Account Manager - Last Name
Account Manager - ID
Servicing Agent - Agency - Name
Servicing Agent - Agency - ID
Servicing Agent - Agent Number
Servicing Agent - Agent Number - ID
Servicing Agent - First Name
Servicing Agent - Last Name
Servicing Agent - Middle Name
Servicing Agent - ID
Additional Agent 1 - First Name
Additional Agent 1 - Last Name
Additional Agent 1 - Middle Name
Additional Agent 1 - ID
Additional Agent 2 - First Name
Additional Agent 2 - Last Name
Additional Agent 2 - Middle Name
Additional Agent 2 - ID
Additional Agent 3 - First Name
Additional Agent 3 - Last Name
Additional Agent 3 - Middle Name
Additional Agent 3 - ID
Additional Agent 4 - First Name
Additional Agent 4 - Last Name
Additional Agent 4 - Middle Name
Additional Agent 4 - ID
Additional Agent 5 - First Name
Additional Agent 5 - Last Name
Additional Agent 5 - Middle Name
Additional Agent 5 - ID
Group Policy - Renewal Percent
Group Policy - New Hire Eligibility - Text
Group Policy - New Hire Eligibility - ID
Group Policy - Eligibility Hours - Text
Group Policy - Eligibility Hours - ID
Group Policy - Rate Method
Group Policy - Waiting Period
Group Policy - Classifications
Group Policy - Notes
Individual Policy - Pay Method - Text
Individual Policy - Pay Method - ID
Individual Policy - Notes
Individual Policy - Member ID
Policy Coverage - Carrier Product - Text
Policy Coverage - Carrier Product - ID
Policy Coverage - Effective Date
Policy Coverage - Premium
Policy Coverage - Renewal Date
Policy Coverage - Status
Policy Coverage - Notes
Policy Coverage - Fees
Policy Coverage - Override FieldSet
Policy Custom Fields Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Group IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDate Of BirthRequired
First Name
MIddle Name
Last Name
ActionThis is an event a Zap performs.SearchFind existing data in your appPhone NumberRequired
First Name
Middle Name
Last Name
ActionThis is an event a Zap performs.SearchFind existing data in your app
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
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 To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
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
Text Bold
Text Italic
Text Strikethrough
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
Bottom-Up
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundActivity Created
Triggers when an Activity is created in AgencyBloc.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Group Created
Triggers when a Group is created in AgencyBloc.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Mask SSN Data
Mask Medicare Beneficiary ID Data
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Policy Created
Triggers when a Policy is created in AgencyBloc.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Create Activities Description
Associated With Description
Associated With - Record TypeRequired
Associated With - Record IDRequired
SubjectRequired
Notes
Activity Status - Text
Activity Status - ID
Activity Type - Text
Activity Type - ID
Activity Priority - Text
Activity Priority - ID
Activity Method - Text
Activity Method - ID
Activity Date
Due Date
Due Date - All Day
Due Date - Start Date & Time
Due Date - End Date & Time
Follow-up User - First Name
Follow-up User - Last Name
Follow-up User - ID
Follow-up Team - Name
Follow-up Team - ID
Parent Activity ID
Attach Files From Zapier
Example Attachment Input
Attachment Files & URLs
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Individuals Description
First NameRequired
Last NameRequired
Middle Name
Nickname
Title
Date of Birth
Gender
Social Security Number
Driver's License Number
Deceased Date
Type - Text
Type - ID
Status - Text
Status - ID
Medicare Beneficiary ID
Medicare Effective Date Part A
Medicare Effective Date Part B
Smoker Status
Servicing Agent - First Name
Servicing Agent - Last Name
Servicing Agent - Middle Name
Servicing Agent - ID
Additional Agent 1 - First Name
Additional Agent 1 - Last Name
Additional Agent 1 - Middle Name
Additional Agent 1 - ID
Additional Agent 2 - First Name
Additional Agent 2 - Last Name
Additional Agent 2 - Middle Name
Additional Agent 2 - ID
Additional Agent 3 - First Name
Additional Agent 3 - Last Name
Additional Agent 3 - Middle Name
Additional Agent 3 - ID
Home Phone Number
Home Phone Number Ext.
Business Phone Number
Business Phone Number Ext.
Cell Phone Number
Cell Phone Number Ext.
Fax Number
Fax Number Ext.
Address Type
Is Primary Address
Address Street 1
Address Street 2
City
County
State/Province
Zip Code
Email Address
Secondary Email Address
Opt-Out Of Emails
Lead Date
Lead Source - Text
Lead Source - ID
Other Lead Source
Lead Agent/Affiliate - First Name
Lead Agent/Affiliate - Last Name
Lead Agent/Affiliate - Middle Name
Lead Agent/Affiliate - ID
Project Code - Text
Project Code - ID
Individual Custom Fields Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Activity IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appIndividual IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEmail AddressRequired
First Name
Middle Name
Last Name
ActionThis is an event a Zap performs.SearchFind existing data in your appPolicy IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
About AgencyBloc
AgencyBloc is an agency management system for L&H insurance agencies that includes CRM, commissions processing, sales, and automation tools.
Related categories
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
Smartsheet
SpreadsheetsRelated Zap Templates
- Create AgencyBloc individuals from new or updated Google Sheets rows
- Create new AgencyBloc groups from new rows in Google Sheets
- Create new individuals in AgencyBloc from new or updated rows in Google Sheets team drive
- Create spreadsheet rows in Google Sheets for new policies in AgencyBloc
- Create new Google Sheets rows for newly created individuals in AgencyBloc