Create invoices from Salesforce opportunity data and add them to Microsoft Excel

■Overview

After closing a deal in Salesforce, creating an invoice and manually entering its details into a Microsoft Excel management sheet can be time-consuming. This workflow automates the entire process—from automatically issuing an invoice in Google Sheets based on Salesforce deal information to recording the details in Microsoft Excel—helping streamline your invoicing operations.

■Recommended for

• Sales representatives who manually create invoices from Salesforce deal information and manage them in Excel
• Accounting teams looking to eliminate data entry errors in the invoicing process and improve accuracy
• Anyone looking to automate data integration between Salesforce and Microsoft Excel and improve operational efficiency

■Benefits of using this template

• Automate everything from closing a deal in Salesforce to issuing an invoice and recording it in Microsoft Excel, reducing the time spent on manual work.
• Eliminate manual data entry to prevent human errors such as incorrect amounts and missing customer information.

■Workflow

1. First, connect Salesforce, Google Sheets, and Microsoft Excel to Yoom.
2. Next, select the Chrome extension as the trigger and configure it to launch the workflow from a Salesforce deal page.
3. Next, configure Salesforce's "Retrieve multiple records" action to retrieve information such as products associated with the deal.
4. Then, configure Salesforce's "Retrieve a record" action to retrieve detailed information about the deal and account.
5. Next, configure Google Sheets' "Issue a document" action to generate an invoice from the template using the retrieved information.
6. Finally, configure Microsoft Excel's "Add a record" action to add the issued invoice details to the management sheet.

※"Trigger": An action that starts the workflow. "Operation": An action that processes data within the workflow after the trigger starts.

■Customization options

• When configuring Salesforce actions, specify your environment's My Domain URL and the API names of the target objects, such as deals and accounts.
• When configuring the Google Sheets action to issue an invoice, set the spreadsheet ID of the template used as the original invoice.
• When configuring the Microsoft Excel action to add a record, specify the destination file and sheet (database).

■Notes

• Connect Salesforce, Google Sheets, and Microsoft Excel to Yoom.
• For details on how to configure a trigger using the Chrome extension, see this guide.
  
• Salesforce is available only on the Team and Success plans. On the Free and Mini plans, operations and Data Connect settings in configured workflows will result in errors.
• Paid plans, such as the Team and Success plans, include a two-week free trial. During the free trial, you can use apps that are otherwise subject to plan restrictions.
  ・Microsoft 365 (formerly Office 365) offers plans for home users and businesses (Microsoft 365 Business). Authentication may fail if you are not subscribed to a business plan.