I’d like to seek some feedback on getting the proper values from Slack to Google Sheet.
I’m trying to retrieve the following from a private channel:
Timestamp
Message sender
I’m using “Message: Timestamp” and “Message: User” these both return integers.
For example, timestamp “2025-04-30 3:13:54” outputs “1745997186”. Username returns also an incorrect value, ex. “U02460CMN2W”, which seems to be a User ID?
I came from Zap and the setup I did was pretty similar, but it was able to get the intended values. Apologies if this was raised previously somewhere but thank you for the help!
According to the Tokens you can use to parse a numeric date variable, you can use X.
e.g.:
{{ parseDate(7.timestamp; "X") }}
Then, you can use the formatDate function with your desired format.
For more information, see Date Format links below.
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
Thanks! I quick question, can I combine parseDate and formatDate in one line, or do I need to pass the value of parseDate to another variable in some way and feed it to formatDate?
I was thinking in the lines of this, but this doesn’t seem to work: