Step 1: I receive a unique identifier (Attendee Key) through Discord,
Step 2: Look up the Attendee Key in a Google Sheet, and
Step 3: Update the Sheet to store the User’s Discord ID, Discord Handle, and the date on which the update happened. I don’t want to update other values in that row.
Is the best approach to use the data in the row from Step 2 to construct all the columns for Step 3? Or is there some way I can define an Update Step array that leaves Column A as is, but changes Column B?
To achieve this workflow, you can follow these steps:
Use the Discord — Reaction Added (Instant) trigger to receive the unique identifier (Attendee Key) from Discord. You can find this trigger by searching for the Discord app in the trigger menu. For more details, visit: https://pipedream.com/apps/discord/triggers/reaction-added
Use the Google Sheets — Search Rows action to look up the Attendee Key in your Google Sheet. You can find this action by searching for the Google Sheets app in the step menu.
Use the Google Sheets — Update Row action to update the row with the User’s Discord ID, Discord Handle, and the date. You can find this action by searching for the Google Sheets app in the step menu.
In the Update Row action, you can define the values you want to update for specific columns, and leave the other columns unchanged. For example, if you want to update Column B, but leave Column A as is, you can specify the new value for Column B in the action, and the other columns will remain the same.
Remember to connect your Discord and Google Sheets accounts in the respective steps.
I’m a bot powered by Pipedream and GPT-4. I’m still learning, so please double check my answers and code! Learn how to build your own.
For example, if you want to update Column B, but leave Column A as is, you can specify the new value for Column B in the action, and the other columns will remain the same.
What does the format for that look like? How do I specify updating Column B only?