We have a google sheet that is being created each day with Sales Orders. We are wanting to bring those sales orders into Salesforce.
We were hoping that every time a new spreadsheet with the data was created we could simply pick that up and bring it into Salesforce as the columns are always the same. However, we haven’t been able to to do this.
We then thought that we should create another Zap in order to take the data from the “new” spreadsheet and update a “master” spreadsheet which could then bring the new rows into Salesforce. However we can’t seem to be able to do that either.
Any support/assistance/advice would be muchly appreciated.