Depending what you’re doing after the spreadsheet step, you might be able to accomplish this with the TODAY function in Excel.

Just use {{zap_meta_human_now}}

Here’s the article on using it:  https://zapier.com/help/create/customize/insert-the-time-your-zap-runs-into-a-field

If you need only the date, try using a formatter step and transforming {{zap_meta_human_now}} to a format that suits you better.

Hey all! I just wanted to pop in here to confirm that using =Today() in the date field would automatically add the current date into your Excel spreadsheet in M/D/YYYY format . For example:

Would appear in Excel as 3/9/2022:


And using {{zap_meta_human_now}} would add both the current date and time. 

So it would appear in MM/DD/YY hh:mmA format:


If there’s a specific date format you’re after you could use a Formatter (Date / Time > Format) step to convert the date into the desired format:

So for the above example 03/09/22 02:13PM (MM/DD/YY hh:mmA) then becomes 03-09-2022 (MM-DD-YYYY):

You can find out more about changing date formats with Formatter here: Modify date and time formats in Zaps