# Recurring export to Google Spreadsheets

**URL:** <https://community.hubspot.com/t/recurring-export-to-google-spreadsheets/22148>\
**Category:** APIs & Integrations\
**Tags:** object\
**Created:** [June 26, 2020, 7:53am UTC](https://community.hubspot.com/t/recurring-export-to-google-spreadsheets/22148 "2020-06-26T07:53:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jpdt](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jpdt/32/57633_2.png) [@jpdt](https://community.hubspot.com/u/jpdt)\
**Post date:** [June 26, 2020, 7:53am UTC](https://community.hubspot.com/t/recurring-export-to-google-spreadsheets/22148/1 "2020-06-26T07:53:55Z")

</div>

Hi all,

I’m working on a script enabling me to export data via the Hubspot API to a Google Spreadsheet. I’m having some issues with finding the right variablenames.

This is (part of) the JS script I have so far:

 ![28595iDB6E939238B9C875.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/9/b/9bdb0d23734358a1b365f93bce84dfc2deecf90c.png)  
Jsscript

This returns the following output. I have the following questions:

- Why are all ownerid’s, teamid’s, and connected\_to\_partner (custom property) not returning the right values?

- How can I make the close date a real date value?

 ![28596i2C563C04305AF298.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/0/7/07d64335ea1f6240821135fb28d8155788f9b505.png)  
Google Spreadsheets

---

<div class="post-metadata">

**Author:** ![WendyGoh](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/wendygoh/32/42320_2.png) [@WendyGoh](https://community.hubspot.com/u/WendyGoh)\
**Post date:** [June 30, 2020, 3:36am UTC](https://community.hubspot.com/t/recurring-export-to-google-spreadsheets/22148/2 "2020-06-30T03:36:25Z")

</div>

Hey @jpdt,

Let’s walk through your question one by one:

1. I believe the reson why the Owner ID, Team ID and Connected to partner properties are returning unknown because the internal value of the properties are as follows:

**hubspot\_owner\_id** , **hubspot\_team\_id** , **connected\_to\_partner**.

Based on your code, it looks like you’re missing the “\_” for these properties.

2. When looking to convert unix milliseconds timestamp to date time, you can use the following formula:

`=(A3/86400/1000)+25569`

where A3 is the cell that contain the timestamp.

I referenced this [stackoverflow](https://stackoverflow.com/questions/46130132/converting-unix-time-into-date-time-via-excel).

---

<div class="post-metadata">

**Author:** ![jpdt](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jpdt/32/57633_2.png) [@jpdt](https://community.hubspot.com/u/jpdt)\
**Post date:** [June 30, 2020, 7:43pm UTC](https://community.hubspot.com/t/recurring-export-to-google-spreadsheets/22148/3 "2020-06-30T19:43:08Z")

</div>

@WendyGoh thank you very much 🙂