Record new lead information registered in Salesforce into a Google Spreadsheet.
Record new lead information registered in Salesforce into a Google Spreadsheet.
Launch this workflow to connect
Salesforce &
Google Sheets
!
■Overview
When new lead information is registered in Salesforce, the information is automatically recorded in a Google Spreadsheet.
You can reflect any fields, such as lead name and contact information, in the spreadsheet.
■Setup Instructions
1. Connect each app, Salesforce and Google Spreadsheet, with Yoom. (My App Integration)
2. Set up the account information to be integrated with the "When a new lead is registered" trigger in Salesforce.
3. In the "Record information in spreadsheet" operation in Google Spreadsheet, set up the target spreadsheet, etc., based on the information obtained from Salesforce.
4. Once the setup is complete, change the trigger to ON at the end.
5. When new lead information is registered in Salesforce, the information is added to the Google Spreadsheet.
■Notes
・It is necessary to set up the account information to be integrated in each app's operation.
・Please replace the setup information for Salesforce and Google Spreadsheet with any desired values.
・Salesforce is an app available only in the Team Plan and Success Plan. In the case of the Free Plan or Mini Plan, the operations and data connections of the configured Flowbot will result in an error, so please be careful.
・Paid plans such as Team Plan and Success Plan offer a 2-week free trial. During the free trial, you can use apps that are subject to restrictions.
Check Out Similar Templates!
Add a record to Microsoft Excel when a record is registered in a Salesforce custom object.
When a record is registered in a Salesforce custom object, it is added to the Microsoft Excel database. This flow improves work efficiency by eliminating the need for manual data entry by the person in charge.
See more
About the Apps
Salesforce
Templates using
Salesforce
When a ToDo object is registered in Salesforce, it is added to the Google Spreadsheet database. This flow frees the person in charge from the redundant manual input tasks, allowing them to focus on their core duties.
This is a business workflow that automatically adds a contact to Mailchimp when the lead status is updated in Salesforce. Automating data synchronization streamlines customer management.
This is a business workflow that automatically adds lead information registered in Salesforce to Notion. It reduces manual input and streamlines information sharing across the entire team.
Templates using
Google Sheets
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
About the apps you use
Salesforce
With Yoom, you can utilize Salesforce's API without any coding. For example, you can retrieve information from Salesforce via the API and integrate it with other SaaS or create documents. Additionally, you can synchronize Salesforce lead information and deal information with Yoom's database for various purposes.
see detailsTemplates
When a ToDo object is registered in Salesforce, it is added to the Google Spreadsheet database. This flow frees the person in charge from the redundant manual input tasks, allowing them to focus on their core duties.
Add a Google Spreadsheet entry when a ToDo object is registered in Salesforce.
This is a business workflow that automatically adds a contact to Mailchimp when the lead status is updated in Salesforce. Automating data synchronization streamlines customer management.
Add a contact to Mailchimp when the lead status in Salesforce is updated.
This is a business workflow that automatically adds lead information registered in Salesforce to Notion. It reduces manual input and streamlines information sharing across the entire team.
Add lead information registered in Salesforce to Notion.
Google Sheets
At Yoom, you can utilize the Google Sheets API without any coding. By integrating Sheets with Yoom, you can automate data entry into spreadsheets and automatically create documents based on spreadsheet templates. Additionally, you can sync spreadsheet information with Yoom's database for various applications.
see detailsTemplates
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
Add order information to WooCommerce when a row is added in Google Sheets.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
Add a new tab to the Google Spreadsheet at the beginning of each month.
No-Code API Actions
Executable API actions
Flowbot triggers
When a new record is registered in the lead object
When a new record is registered in the account object
When a new record is registered in the opportunity object
When a new record is registered in the contact object
When a record is registered or updated in the lead object
When a record is created or updated in the Account object
When a record is created or updated in the Opportunity object
When a record is created or updated in the Contact object
When a new record is created in the Custom Object
When a record is created or updated in the Custom Object
When a record is registered in the Activity object
When a record is registered in the ToDo object
When an outbound message is received
When a file is uploaded
When a calendar event is created
When a calendar event is updated
When a calendar event is deleted
When a row is added
Flowbot operations
Get Lead records
Update Lead Records
Create Lead Record
Search Lead records
Get Latest Lead Record
Get Account records
Update Account records
Create Account Record
Search Account records
Get Opportunity Record
Update Opportunity records
Create Opportunity Record
Search Opportunity records
Get Contact Record
Update Contact records
Create Contact Records
Search Contact records
Get Custom Object Record
Flowbot triggers
When a new record is registered in the lead objectWhen a new record is registered in the account objectWhen a new record is registered in the opportunity objectWhen a new record is registered in the contact objectWhen a record is registered or updated in the lead objectWhen a record is created or updated in the Account objectWhen a record is created or updated in the Opportunity objectWhen a record is created or updated in the Contact objectWhen a new record is created in the Custom ObjectWhen a record is created or updated in the Custom ObjectWhen a record is registered in the Activity objectWhen a record is registered in the ToDo objectWhen an outbound message is receivedWhen a file is uploadedWhen a calendar event is createdWhen a calendar event is updatedWhen a calendar event is deleted
Flowbot operations
Get Lead recordsUpdate Lead RecordsCreate Lead RecordSearch Lead recordsGet Latest Lead RecordGet Account recordsUpdate Account recordsCreate Account RecordSearch Account recordsGet Opportunity RecordUpdate Opportunity recordsCreate Opportunity RecordSearch Opportunity recordsGet Contact RecordUpdate Contact recordsCreate Contact RecordsSearch Contact recordsGet Custom Object RecordUpdate Custom Object RecordCreate Custom Object RecordSearch custom object recordsLink a File to a RecordUpload a File to Link to a RecordGet the Content Document ID of the Uploaded FileSearch Lead Records (Excluding Deleted Records)Search Account Records (Excluding Deleted Records)Search Opportunity Records (Excluding Deleted Records)Search Contact Records (Excluding Deleted Records)Search Custom Object Records (Excluding Deleted Records)Download ReportLog Activity on LeadLog Activity on AccountLog Activity on Opportunity RecordLog Activity on ContactCreate To-Do on LeadCreate ToDo on Account ObjectCreate Task on OpportunityCreate Task on ContactLog Activity on LeadCreate Event on AccountCreate Event on OpportunityCreate Event on ContactLog Email Message to OpportunityLog Email Message to AccountCreate User RecordCreate Email MessageAssociate Email Message with PersonAdd Email Message to Custom ObjectLog Activity on a Custom ObjectCreate To-Do on a Custom ObjectLog Activity on Custom ObjectGet Content IDs of Files Related to a RecordGet Latest Content Version IDDownload FilesGet Contract RecordUpdate Contract recordsCreate Contract Object RecordDelete Contract RecordCreate Calendar EventSearch User Object RecordsGet User RecordUpdate Account ActivitySearch Account ActivitiesGet User ListGet Account ListGet Contact ListGet Opportunity ListGet Lead ListGet Case ListGet Campaign ListGet Object ListGet Custom Object ListGet Chatter Group ID ListPost to User on ChatterPost to Account on ChatterChatterを取引先責任者に投稿Chatterを商談に投稿Chatterをリードに投稿Chatterをケースに投稿Post to Campaign ChatterPost to Custom Object ChatterChatterをChatterグループに投稿Get Channel Listユーザーオブジェクトのレコードの更新Create User RoleAssign User Roleユーザーオブジェクトの権限セット割り当ての作成Associate a Contract record with an Opportunity recordユーザーオブジェクトの権限セット割り当てを削除ユーザーを指定グループに追加ユーザーを指定グループから削除Post to ChatterAdd User to Chatter GroupGet File NameGet Email MessagesSearch Records with SOQL
Flowbot triggers
When a row is addedWhen a row is updated
Flowbot operations
Set a value in a cellGet valuesClear valuesCreate a new spreadsheetCopy a sheet (tab)Add a new sheet (tab)Delete Sheet (Tab)Replace valuesUpdate Sheet NameDelete RowsGet Spreadsheet InfoGet sheet namesApply a formula to a rangeEnter values in a rangeEmbed an image in a cellSort by specific columnHide a sheetAdd a note to the specified cellsInsert columnsDelete columnsWrite values to multiple columnsMore inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
