We currently have a large extensive onboarding tracker that is an excel spreadsheet that lives on our SharePoint Online site. Our onboarding team uses this tracker to ensure each task (couple hundred tasks per new customer) that must be completed during the onboarding process has been executed properly. However, we use Salesforce as our CRM for all the tracking of the customer lifecycle journey and customer communications from Opportunities (prospect customers) to Accounts (active customers) data. We want to setup a workflow that will allow the Salesforce data for new customers/account to auto-populate onto the onboarding tracker excel spreadsheet in SharePoint.
This is our initial thought but if there is a better solution/workflow for this, please advise. The workflow steps we are thinking of would be:
But where is the option (or workflow action we need to choose) where we setup from the data we retrieved from the Salesforce record that we need to have populated onto the Excel Tracker in SharePoint to have it populate the Salesforce data into the appropriate row, column, and cell on that spreadsheet?
Solved! Go to Solution.
@christinatap sorry I'm a little confused. Are you actually trying to update fields within SharePoint, or is the Excel workbook actually attached to a SharePoint list item, or is it just a document that is *held* within a SharePoint library? Depending on how you're storing things in SharePoint the answer will be different.
@butlerj It's an Excel spreadsheet that is "held" within SharePoint. However, we are open to creating an Excel workbook attached to a SharePoint list item if that would work better.
@christinatap if you'd like to actually update the values *inside* the Excel sheet you will need to use a custom Xtension action and work with the Excel API as Nintex Workflow Cloud does not have any native Excel actions yet. If you'd like an example of this, we have a Read Excel File action in the Nintex Gallery that you might be able to use as a jumping off point.