topic Re: Form > Zapier > Google Sheets- Timestamp? in Marketing Integrations

Form > Zapier > Google Sheets- Timestamp?

ellenrathburn — Mon, 29 Jul 2019 12:35:08 GMT

I am using zapier to create rows on a spreadsheet as form-fills are submitted to create warranty requests for my company's tech department. I would like to find a way to create a timestamp within the spreadsheet, or generate an ID number automatically. Has anyone found a way to accomplish this?

Re: Form > Zapier > Google Sheets- Timestamp?

Ben_M — Tue, 30 Jul 2019 15:58:11 GMT

The timestamp should be easy to solve for. If Zapier cannot grab that data from the form submit, I would just create a date property and populate that. If you need a true datestamp, just modify your form embed code and include it via javascript ( https://developers.hubspot.com/docs/methods/forms/advanced_form_options ). Then pass that property through Zapier.

The problem with generating an ID number depends on the complexity of the number, whether it is auto increment or whether it is some custom string. If you can generate it via API or script prior to the form submission you may be able to pass it as a property. If not I'm a bit short of ideas because the thought going through my mind is keeping it in sync between platforms.

Re: Form > Zapier > Google Sheets- Timestamp?

meelad — Mon, 06 Apr 2020 18:07:59 GMT

Do you want a date appended as it's own column everytime a new row is added to your Google Sheet?

Re: Form > Zapier > Google Sheets- Timestamp?

olga_rusnak — Fri, 10 Apr 2020 16:41:17 GMT

Hi @ellenrathburn

So, I am going to suggest another option:

- You can use Google Sheets add-on called Coupler.io to pull your data from HubSpot to Google Sheets on a set schedule (it currently offers down to 1-hour data refresh frequency)

- So, for example, you will pull Deals (or People, or Organizations data) - depending on that what type of data category gets created in HubSpot after a person filled out a form.

- If you want Coupler.io to retrieve Deals, it will pull all other Deals properties, like:

Deal name
Deal owner
Deal stage
Amount
Deal description
Create date - this is what you need!
Close date
etc.

- Then you just call the sheet where you pull this data - deals raw data (for instance) - and refer to it from other views when building dashboard and/or performing other types of calculations.

It would be interesting to find out what you think about this option!

Re: Form > Zapier > Google Sheets- Timestamp?

Aspermont — Tue, 14 Jul 2020 14:13:52 GMT

Hello,

I'm still looking for a solution to map the contact form submission date -> Zapier -> Google Sheets. I don't see the form submission date in Hubspot properties to add to the Hubspot form.

Any solutions?

Re: Form > Zapier > Google Sheets- Timestamp?

ellenrathburn — Tue, 14 Jul 2020 14:28:01 GMT

Hi Aspermont,

What ended up working for me was using adding the column to my google sheet for the timestamp, and using { {zap_meta_human_now} } with the company-necessary modifiers to add the timestamp. This article may help you out!

https://zapier.com/help/create/customize/insert-the-time-your-zap-runs-into-a-field

Re: Form > Zapier > Google Sheets- Timestamp?

jasonashaw — Sun, 01 Nov 2020 14:36:10 GMT

THANK YOU!!! Worked Perfectly.