Hi. I am setting up an integration from Thinkific to smartsheet.
I have already set up the trigger to create a new row in Smartsheet when a new student registers.
Now I want to automatically update that row when the student enrols on a Free Preview; effectively I need to update an existing row by adding in the course they have enrolled on. This will be done using the student’s unique ID created by Thinkific, which has a specific column in smartsheet.
The first 3 steps are complete in the screen shot below. But my dropdown menu does not have the Lookup Spreadsheet Row option n the standard event list.
- Click the plus + icon to add an action step.
- Search for and select Google Sheets.
- Connect or select to your Google Sheet account.
- Click the Event dropdown menu and select Lookup Spreadsheet Row.
The option for ‘new row update’ is there, but it won’t work if I haven’t set where the row ID can be found.
Help please.
