Getting the correct timestamp/username from Slack to a Google Sheet

Hello!

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?

Here’s the fields I setup:

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!

Hey there,

just to be clear, you are getting the proper values. It’s just that you are getting them raw and not reformatted to a human readable state.

The date you are getting is a UNIX time stamp, you can convert it to whatever you need using the formatDate() function.

Then yes, you are getting the user ID. You can use the Get a User module to find out their name.

1 Like

Welcome to the Make community!

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 —

Getting Started

Help Centre Basics

Articles & Videos

Hope this helps! Let me know if there are any further questions or issues.

@samliew

Thanks for the feedback! I didn’t notice that there’s a Get a User module so I’ll try that!

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:

parseDate(7.message.ts; formatDate(“X”; “YYYY-MM-DD HH:mm:ss”; “Asia/Hong_Kong”))

parseDate has to come first of course. You have it the other way around.

1 Like