When a row is updated in Google Sheets, update the Salesforce record as well.
When a row is updated in Google Sheets, update the Salesforce record as well.
Launch this workflow to connect
Google Sheets &
Salesforce
!
■Overview
This is a flow that updates Salesforce records when a row is updated in Google Sheets.
■Recommended for
1. Those who use Google Sheets for business
・Office workers who manage shared sheets and share information
・HR personnel who share sheets with multiple offices to share employee information
2. Companies managing deals with Salesforce
・Those who manage and share progress for each project within the team
・Sales managers who oversee all internal projects
■Benefits of using this template
Google Sheets helps to smoothly accumulate and share information, facilitating business operations.
However, manually entering updates in both Google Sheets and Salesforce is inefficient and time-consuming.
This flow is suitable for those who want to reflect updates without spending time.
By referencing updates in Google Sheets to edit Salesforce information, it prevents manual errors and saves effort.
■Notes
・Please integrate both Google Sheets and Salesforce with Yoom.
・Salesforce is an app available only with the Team Plan and Success Plan. If you are on the Free Plan or Mini Plan, operations and data connections set in the flow bot will result in errors, so please be careful.
・Paid plans such as the Team Plan and Success Plan offer a 2-week free trial. During the free trial, you can use apps that are usually restricted.
Check Out Similar Templates!
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.
Add order information to WooCommerce when a row is added in Google Sheets.
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 a new tab to the Google Spreadsheet at the beginning of each month.
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 user to Zoom when a row is added in Google Sheets.
This is a flow for adding users to Zoom when a row is added in Google Sheets. Based on the added information, users are automatically registered, eliminating the need for manual work. The time previously spent on manual tasks can be allocated to other tasks, increasing the pace of business operations.
See more
About the Apps
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.
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.
About the apps you use
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.
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.
No-Code API Actions
Executable API actions
Flowbot triggers
When a row is added
When a row is updated
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
Flowbot operations
Set a value in a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Info
Get sheet names
Apply a formula to a range
Enter values in a range
Embed an image in a cell
Sort by specific column
Hide a sheet
Add a note to the specified cells
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 columns
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 Document IDs Associated with a RecordGet Latest Content Version IDDownload FilesGet Contract RecordUpdate Contract recordsCreate Contract Object RecordDelete Contract RecordCreate Calendar EventSearch User RecordsGet User RecordUpdate Account ActivitySearch Account ActivitiesGet UsersGet Account ListGet Contact ListGet Opportunity ListGet Lead ListGet Case ListGet Campaign ListList ObjectsList Custom ObjectsList Chatter Group IDsPost 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 using SOQLMore inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
