Hello, See below for my requirement
I would like a new record in salesforce to trigger the creation/copy of an existing Google Sheet and then a new row inserted on that new spreadsheet with date from the Salesforce record
Solution
Trigger: 1. New Record in SalesForce
Action: 2. Create Spreadsheet in Google Sheets
-------Spreadsheet to Copy: Select template sheet
-------Headers: Blank
Action: 3. Create Spreadsheet Row
-------Spreadsheet, Custom: 2. ID
-------Worksheet: Selected worksheet to insert new row
I Can get all of this set up, but it never asks me which fields to put in the new row that are from the New Salesforce record? It does that when I do a normal create spreadsheet row so im thinking it has something to do with me making this a 3rd action after the create spreadsheet action.