Google Sheets + Kiflo PRM
Create new Kiflo PRM partners from new or updated rows in Google Sheets
Keep your partner relationships in Kiflo PRM up-to-date with this automation. With this workflow, any new or updated row in your Google Sheets will create a new partner in Kiflo PRM. Experience seamless data management without lifting a finger, saving you time to focus on fostering those relationships.
Keep your partner relationships in Kiflo PRM up-to-date with this automation. With this workflow, any new or updated row in your Google Sheets will create a new partner in Kiflo PRM. Experience seamless data management without lifting a finger, saving you time to focus on fostering those relationships.
- 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!
Create PartnerTriggers when a new partner is added.
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
Business Plan Objective Updated
Triggers when a business plan objective's current value is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact Updated
Triggers when a property on an existing contact is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer Updated
Triggers when a new customer is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deal Added
Triggers when a new deal is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deal Stage Changed
Triggers when a deal moves to a new stage.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deal Updated
Triggers when a property on an existing deal is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Lead Added
Triggers when a new lead is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Lead Refused
Triggers when a new lead is refused.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Partner Application Accepted
Triggers when a partner application is accepted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Partner Application Rejected
Triggers when a partner application is rejected.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Partner Note Added
Triggers when a new note is added on a partner.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Partner Prospection Stage Updated
Triggers when the prospection stage of a partner is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Payout Created
Triggers when a new payout is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Partner Added to Program Level
Triggers when a partner as added to a new program level.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Team Member Added
Triggers when a new team member is added to an existing partner.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Transaction Updated
Triggers when a new transaction is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Create Contact
Creates a new contact.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source partner
Status
Source
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DealRequired
Note
Is note visible to partner?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DealRequired
CustomerRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DealRequired
NoteRequired
Is note visible to partner?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
Note
Is note visible to partner?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
NoteRequired
Is note visible to partner?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create note onRequired
ContentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Partner ApplicationRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Partner Team MemberRequired
Email TemplateRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Partner IDRequired
Onboarding Pipeline IDRequired
Onboarding Stage ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PayoutRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PayoutRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PayoutRequired
Partner should validate rewards
Partner should attach an invoice
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CurrencyRequired
Partner
Customer
Deal
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Field to Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
Source partner
Status
Source
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundField to Search ByRequired
Assigned partner
Assigned contact
Is the partner the source?
Currency
Tracking code
Status
Note
Additional properties (Obsolete - Do not use)
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundField to Search ByRequired
CurrencyRequired
Partner
Customer
Deal
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
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 foundContact Added
Triggers when a new contact is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer Added
Triggers when a new customer is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deal Accepted
Triggers when a new deal is accepted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deal Note Added
Triggers when a new note is added on a deal.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deal Refused
Triggers when a new deal is refused.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Lead Accepted
Triggers when a new lead is accepted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Lead Note Added
Triggers when a new note is added on a lead.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Lead Updated
Triggers when a new lead is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Partner Application Added
Triggers when a new partner application is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Partner Added
Triggers when a new partner is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Partner Onboarding Stage Updated
Triggers when a partner moves to a new onboarding stage.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Partner Updated
Triggers when a new partner is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Payout Status Changed
Triggers when a payout status has changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Reward Created
Triggers when a new reward is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Transaction Added
Triggers when a new transaction is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Lead
Deal
NameRequired
Source NameRequired
Source URL
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
Partner
Status
Source
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Deal IDRequired
Partner IDRequired
Role
Source
Use default rewards
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stage
Close date
Currency
Create a new contact?
Additional properties (Obsolete - Do not use)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
Stage
Close Date
Currency
Additional properties (Obsolete - Do not use)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Assigned partner
Assigned contact
Is the partner the source?
Currency
Tracking code
Status
Note
Additional properties (Obsolete - Do not use)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
Partner
Currency
Note
Additional properties (Obsolete - Do not use)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Partner ApplicationRequired
Has access to Kiflo?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CertificationRequired
Partner Team MemberRequired
StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Partner nameRequired
Status
Partner program
Onboarding stage
Group
Partner type
Payout provider
Language
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
Partner name
Status
Prospection stage
Onboarding stage
Partner program
Currency
Group
Payout provider
Language
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Partner
Currency
Reward Type
Reward Status
Threshold
From
To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Partner
AmountRequired
CurrencyRequired
Reward typeRequired
CommentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEmailRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundField to Search ByRequired
Stage
Close date
Currency
Create a new contact?
Additional properties (Obsolete - Do not use)
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundField to Search ByRequired
Partner nameRequired
Status
Partner program
Onboarding stage
Group
Partner type
Payout provider
Language
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
About Google Sheets
Related categories
About Kiflo PRM
Related categories
Related Zap Templates
- Create spreadsheet rows in Google Sheets when new deals are added in Kiflo PRM
- Update Google Sheets rows every time a deal is updated in Kiflo PRM
- Create spreadsheet rows in Google Sheets when new leads are added in Kiflo PRM
- Create transactions in Kiflo PRM from new rows in Google Sheets
- Update Google Sheets rows with each transaction update in Kiflo PRM