Google Sheets + Revolear
Look up contacts by email in Revolear for new spreadsheet rows in Google Sheets
With this workflow, as soon as you add a new row to your Google Sheets, it promptly looks up the corresponding contact in the Revolear app using the contact's email provided in the spreadsheet. This efficient method ensures you have a well-maintained and up-to-date contact list, saving you from the hassle of manual updates. Perfect for those looking to streamline their contact management process.
With this workflow, as soon as you add a new row to your Google Sheets, it promptly looks up the corresponding contact in the Revolear app using the contact's email provided in the spreadsheet. This efficient method ensures you have a well-maintained and up-to-date contact list, saving you from the hassle of manual updates. Perfect for those looking to streamline their contact management process.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Look Up Contact by Contact EmailLook up a Revolear contact by its unique identifier in Revolear.
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
Customer Comment Received
Triggers when a Contact sends a comment on a proposal or agreement.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Agreement Signature Complete
Triggers when all signatories when completed the signature process for an agreement.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Share Proposal or Agreement
Triggers when a version of a proposal or agreement is shared with a customer.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Submit Form
Triggers when a form is submitted
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Create/Update Account
Triggers when a account is created/updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.View Proposal or Agreement
Triggers when a Contact views a proposal or agreement.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Solution IdRequired
Solution Element PathRequired
User Context Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailsRequired
Solution IdRequired
User Context Email
First Name
Last Name
Phone
Company
Image URL
Salutation
Title
Enriched
Management Level
Contact Accuracy Score
Country
Region
metroArea
Position Start Date
Years of Experience
City
LinkedIn URL
Scheduling URL
Job Function
Department
IsOrgSignatory
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Solution IdRequired
Envelope Id
User Context Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Solution IdRequired
Proposal IdRequired
User Context Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Revolear Account IDRequired
User Context Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Revolear Account ID
User Context Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Revolear Solution External ID
User Context Email
CRM Integration Platform
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Revolear Product Name
Revolear Product Display Label
User Context Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Solution IdRequired
Site NameRequired
User Context Email
Show Contact Card
Contact Card User Id
Deafult Page Name
Pages Name
message
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Solution IdRequired
User Context Email
Elements to be updated
Agreement Date
Account Primary
Amount Primary Abbreviation
Amount Secondary
Amount Secondary Abbreviation
Amount Tertiary
Amount Tertiary Abbreviation
Annual Contract Value
Annual Recurring Revenue
Approval Status
Created Date
Currency Code
Effective Date
Effective Duration
End Date
Name
Owner Id
Status
Opportunity ID
Opportunity Name
HubSpot ID
HubSpot Deal Name
External ID
Opportunity Stage
Account ID
Primary Contact Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record 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 foundDeal Created
Triggers when a new deal is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Agreement Sent for Signature
Triggers when a user sends an agreement for Signature.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Publish Proposal
Triggers when a proposal is published.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer Suggestion Received
Triggers when a Contact sends a suggestion on a proposal or agreement.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Create/Update Contact
Triggers when a contact is created/updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Solution IdRequired
Proposal IdRequired
EmailsRequired
User Context Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Account URLRequired
Account NameRequired
User Context Email
Account Nickname
Account phone number
Account city
Account country
Account zip code
Account State
Account Street
Account Description
Account Website
Account Legal Form
Additional Inputs
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.User Context Email
Additional Inputs
Name
External Id
Revolear Solution Model NameRequired
Effective Date
Duration
End Date
Party Id
Primary Email
Status
Account Id
primaryDealTeam
opportunityId
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Solution IdRequired
Template NameRequired
User Context Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Solution IdRequired
Proposal IdRequired
EmailsRequired
User Context Email
Email Template Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Revolear Contact EmailRequired
User Context Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Revolear Solution ID
User Context Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Revolear Solution Name
User Context Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Revolear Solution ID
User Context Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Solution IdRequired
Form NameRequired
Additional Inputs
User Context Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
About Google Sheets
Related categories
About Revolear
Related categories
Related Zap Templates
- Create new Revolear accounts from new Google Sheets rows
- Create new Revolear contacts from new rows in Google Sheets
- Update Revolear deals whenever new rows are added in Google Sheets
- Create Google Sheets rows for new agreements sent for signature in Revolear
- Look up new deals in Revolear when new rows are added in Google Sheets
- Look up new Revolear deals by name when new rows are added to Google Sheets
- Create new spreadsheet rows in Google Sheets and look up accounts by id in Revolear
- Look up deals by account id in Revolear for every new row in Google Sheets
- Create spreadsheet rows in Google Sheets for completed signature agreements in Revolear
- Create new Revolear deals from new rows in Google Sheets team drive