Skip to main content

Hello. We have a client that switched to SquareSpace. In the transition, they removed Formstack Forms from their website and have decided to use the default SquareSpace forms. 

On the old website, we had a connection set up with Zapier that pulled the information into a Google sheet. Though it was hidden on the form, we were able to pull down submission date data (including time of submission) and was able to use that for our analytics and tracking. 

Using the SquareSpace form, we are unable to pull in any submission data it seems. Is there a way to pull down time/date of submission, without making the person do that on the form? 

Hi @OhYaMarketing, welcome to the community!

That’s a great question, and there’s a simple way to do this :) 

Each time a form is submitted and a new row is created in Google Sheets, you can add a timestamp of when the row was created, effectively adding the date/time of when the form was completed. 

To add the date/timestamp you add the phrase {{zap_meta_human_now}} to the relevant field in your Zap (ie the corresponding column in Google Sheets). 

You can learn more about adding the current date/time to your Zaps in this help guide: Insert the time your Zap runs into a field

One thing to know about the {{zap_meta_human_now}} stamp is that when you test the Zap, it will insert the date and time using UTC (universal time). When your Zap is turned on, it will use the timezone of your Zapier account (or the Zap if you have set a different timezone for your Zap). So, if the time looks wrong when you test the Zap in the Zap editor, don’t worry. Turn on the Zap and submit a test form to check it. 

 

A final tip is to make sure that the date column in Google Sheets is formatted to date/time before you turn on the Zap. If you’re note sure how to do that, here’s a Google help doc on formatting numbers in columns.

 

​I hope that's clear, please let us know if you have any questions!