# Add data form google docs to property **URL:** \ **Category:** Reporting & Analytics\ **Tags:** workflows\ **Created:** [April 3, 2024, 8:16am UTC](https://community.hubspot.com/t/add-data-form-google-docs-to-property/103982 "2024-04-03T08:16:11Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![FBenda](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/fbenda/32/24945_2.png) [@FBenda](https://community.hubspot.com/u/FBenda)\ **Post date:** [April 3, 2024, 8:16am UTC](https://community.hubspot.com/t/add-data-form-google-docs-to-property/103982/1 "2024-04-03T08:16:11Z")
Hi All, For context; we’re an online platform that offers discounts to cultural outings like museums and theatre. One of the cultural partners want to distribute a single use code per online user. So when someone is interested in that activity, they will receive an e-mail from us with a unique discount code. Not all of our users will use this code. Here’s my problem; I can’t figure out how to distribute these unique codes automated. I was thinking about creating a workflow that fills a custom property with the code once a form is submitted, and then an e-mail will be sent to the submitter with the discount code. But now I can’t figure out how to fill the new custom property without too much handwork, I also don’t want to add a discount code to every user perse. (Just updating properties would be easier I know). Is it possible to, for instance retrieve the discount code from a google docs? Or fill the property in any other way? Maybe someone has different insights on this, or ideas? Thanks in advance for your help! ---
**Author:** ![PamCotton](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/pamcotton/32/47916_2.png) [@PamCotton](https://community.hubspot.com/u/PamCotton)\ **Post date:** [April 3, 2024, 9:00pm UTC](https://community.hubspot.com/t/add-data-form-google-docs-to-property/103982/2 "2024-04-03T21:00:00Z")
Hey @FBenda, thank you for posting in our Community! Since you mentioned Google Docs, you can use Google Sheets to store a list of unique discount codes. Each time a user requests a discount, your system can automatically fetch an unused code from the Google Sheets. To our top experts, @TomM2, **@CHawkins,** and @[**DGarg**](https://community.hubspot.com/t5/user/viewprofilepage/user-id/265033) do you have any recommendations for **@FBenda?** Thank you, Pam ---
**Author:** ![CHawkins](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/chawkins/32/87643_2.png) [@CHawkins](https://community.hubspot.com/u/CHawkins)\ **Post date:** [April 3, 2024, 9:13pm UTC](https://community.hubspot.com/t/add-data-form-google-docs-to-property/103982/3 "2024-04-03T21:13:38Z")
Echoing @PamCotton - I think integrating HubSpot and Google Sheets would be the lowest-code solution. Personally, I would probably [add in Zapier](https://zapier.com/apps/google-sheets/integrations/hubspot) to make the fetching of data a little easier, using a workflow trigger based on your needs to fetch a value from Google Sheets as Pam suggested. ---
**Author:** ![FBenda](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/fbenda/32/24945_2.png) [@FBenda](https://community.hubspot.com/u/FBenda)\ **Post date:** [April 4, 2024, 7:27am UTC](https://community.hubspot.com/t/add-data-form-google-docs-to-property/103982/4 "2024-04-04T07:27:02Z")
Thank you both for your reply! How would you recommend going about integrating HubSpot & Google Sheets? I’m pretty new to that one. 🙂 ---
**Author:** ![CHawkins](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/chawkins/32/87643_2.png) [@CHawkins](https://community.hubspot.com/u/CHawkins)\ **Post date:** [April 4, 2024, 12:44pm UTC](https://community.hubspot.com/t/add-data-form-google-docs-to-property/103982/5 "2024-04-04T12:44:08Z")
I am pretty sure you’d need the Zapier integration to work this like you want without having to do your own coding. I was playing a little with it this morning, because I don’t have these exact fields and spreadsheets configured it was a little tricky but here is the idea: ![Screenshot 2024-04-04 at 8.35.47 AM.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/e/e440d66308759b00f223a1110d7f22a11e56131f.png) I would be happy to find some time to look at this with you but, I am actually out of the office next week so I wouldn’t be able to meet until the week of 4/15. [Here](https://meetings.hubspot.com/caseybhawkins) is my meeting link if you want to find 60-minutes that week. ---
**Author:** ![FBenda](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/fbenda/32/24945_2.png) [@FBenda](https://community.hubspot.com/u/FBenda)\ **Post date:** [April 9, 2024, 9:53am UTC](https://community.hubspot.com/t/add-data-form-google-docs-to-property/103982/6 "2024-04-09T09:53:01Z")
Hi Casey, Thanks for helping me (us actually). We found a way in zapier based on what you suggested. Very thankfull! ---
**Author:** ![FBenda](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/fbenda/32/24945_2.png) [@FBenda](https://community.hubspot.com/u/FBenda)\ **Post date:** [April 9, 2024, 9:54am UTC](https://community.hubspot.com/t/add-data-form-google-docs-to-property/103982/7 "2024-04-09T09:54:16Z")
Thanks Casey, with your solution we figured it our in Zapier. Very thankfull for your help.