■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.
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
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
Write values to a range
Insert image into a cell
Sort by a specific column
Hide a sheet
Add a note to the specified cells
When a row is addedWhen a row is updated
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 rangeWrite values to a rangeInsert image into a cellSort by a specific columnHide a sheetAdd a note to the specified cellsInsert columnsDelete columnsWrite values to multiple columns
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
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 ReportsLog 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 a PersonAdd Email Message to Custom ObjectLog Activity on a Custom ObjectCreate To-Do on a Custom ObjectCreate Event on a 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 AccountsGet 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 Name
