Don’t know if its possible but what I am trying to do is make a chain that will see when a new discord message is sent in a channel with specific text then send the User who sent it and the date it was sent into a google doc then populate that date into a specified cell in a roster document based on the User name and only update that persons last time they sent a message.
Example: A
Discord Message: Dave: Hi
first google doc Username Date Message Sent
Dave 6/29/2022 <-------------------------
| Move this date to second google doc
Second Google Doc | based on the user name.
Username Blah Blah Date |
Dave 6/29/2022 <--------------
Sally 6/14/2022
Best answer by jesse
Hey @CtrlAltDelirious welcome to the Community! Loving the username by the way. 😛
Okay, let’s see if we can break this down and see what’s possible here! When I’m building a workflow, I like to think about it in terms of apps and steps. For example:
Discord: New message posted to channel
Filter by Zapier: Only continue if the message text contains (you decide)
Google Sheets: Create Row (First sheet)
Google Sheets: Find/Create Row (Second Sheet) (Based on username - this will create a row for the username if one isn’t found)
Hey @CtrlAltDelirious welcome to the Community! Loving the username by the way. 😛
Okay, let’s see if we can break this down and see what’s possible here! When I’m building a workflow, I like to think about it in terms of apps and steps. For example:
Discord: New message posted to channel
Filter by Zapier: Only continue if the message text contains (you decide)
Google Sheets: Create Row (First sheet)
Google Sheets: Find/Create Row (Second Sheet) (Based on username - this will create a row for the username if one isn’t found)
Hey @CtrlAltDelirious! I wanted to check in to see if my previous suggestions helped get you on track. Let us know - we want to help get you up and running with this workflow!
