AgencyBloc + Google Sheets
Create new individuals in AgencyBloc from new or updated rows in Google Sheets team drive
Keep your agency data updated hassle-free. With this automation, every time a new row is added or updated in Google Sheets (Team Drive), it immediately creates an individual record within AgencyBloc. This workflow ensures your client information in AgencyBloc mirrors your Google Sheets data, keeping everything up-to-date and aligned.
Keep your agency data updated hassle-free. With this automation, every time a new row is added or updated in Google Sheets (Team Drive), it immediately creates an individual record within AgencyBloc. This workflow ensures your client information in AgencyBloc mirrors your Google Sheets data, keeping everything up-to-date and aligned.
- When this happens...
New or Updated Spreadsheet Row (Team Drive)Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.
TriggerPollingZapier checks for new data every 15 min on the Free plan - 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 ZapPollingZapier 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.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.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 found
Activity 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
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 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 foundActivity 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
About AgencyBloc
Related categories
About Google Sheets
Related categories
Related 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 rows in Google Sheets
- Create spreadsheet rows in Google Sheets for new policies in AgencyBloc
- Create new Google Sheets rows for newly created individuals in AgencyBloc