# From Google Sheets to GF **URL:** \ **Category:** Get Help\ **Tags:** google-sheets, dynamic-population, gravity-wiz\ **Created:** [July 17, 2021, 1:45pm UTC](https://community.gravityforms.com/t/from-google-sheets-to-gf/10317 "2021-07-17T13:45:01Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![luismiguelrosero](https://sea2.discourse-cdn.com/flex020/user_avatar/community.gravityforms.com/luismiguelrosero/32/3276_2.png) [@luismiguelrosero](https://community.gravityforms.com/u/luismiguelrosero)\ **Post date:** [July 17, 2021, 1:45pm UTC](https://community.gravityforms.com/t/from-google-sheets-to-gf/10317/1 "2021-07-17T13:45:01Z")
You tried to dynamically fill a product field with the information found in a cell of a google spreadsheet, for example C3 (column C row 3) Will someone please know or could explain to me how I can achieve this task, thanks in advance. The information travels from google spreadsheets to the form made with Gravity Forms ONLY in that sense, NOT the other way around. ---
**Author:** ![chrishajer](https://sea2.discourse-cdn.com/flex020/user_avatar/community.gravityforms.com/chrishajer/32/88_2.png) [@chrishajer](https://community.gravityforms.com/u/chrishajer)\ **Post date:** [July 19, 2021, 5:49pm UTC](https://community.gravityforms.com/t/from-google-sheets-to-gf/10317/2 "2021-07-19T17:49:26Z")
Hello. This would require some customization and some code, but Google Sheets has an API: > **[Basic Reading  |  Sheets API  |  Google Developers](https://developers.google.com/sheets/api/samples/reading)** And if you can retrieve the data via the API, you can use the gform\_field\_value filter to populate a field in the form: > **[gform\_field\_value\_$parameter\_name - Gravity Forms Documentation](https://docs.gravityforms.com/gform_field_value_parameter_name/)** > > This filter is executed before displaying each field and can be used to dynamically populate fields with a default value. I found a relatively recent tutorial which covers this in depth (and with a more complicated task than what you are asking): > **[Dynamically Populate Gravity Forms from Google Sheets (GSheets APIv4) -...](https://bachelor-tech.com/tutorials/dynamically-populate-gravity-forms-from-google-sheets-apiv4/)** > > In this tutorial, we will create a Google API key, install required software on our web server via SSH. We will then download contents from GSheets (APIv4) and pass on the requested values into Gravity fields using Gravity API (GFAPI). ---
**Author:** ![luismiguelrosero](https://sea2.discourse-cdn.com/flex020/user_avatar/community.gravityforms.com/luismiguelrosero/32/3276_2.png) [@luismiguelrosero](https://community.gravityforms.com/u/luismiguelrosero)\ **Post date:** [July 19, 2021, 9:37pm UTC](https://community.gravityforms.com/t/from-google-sheets-to-gf/10317/3 "2021-07-19T21:37:40Z")
wowww great , thank you very much, i will check everything ---
**Author:** ![chrishajer](https://sea2.discourse-cdn.com/flex020/user_avatar/community.gravityforms.com/chrishajer/32/88_2.png) [@chrishajer](https://community.gravityforms.com/u/chrishajer)\ **Post date:** [July 19, 2021, 9:39pm UTC](https://community.gravityforms.com/t/from-google-sheets-to-gf/10317/4 "2021-07-19T21:39:36Z")
Thanks Luis. I closed the Contact Us ticket you submitted as well, because my answer there was going to be the same as here 🙂 ---
**Author:** ![richardw8k](https://sea2.discourse-cdn.com/flex020/user_avatar/community.gravityforms.com/richardw8k/32/2354_2.png) [@richardw8k](https://community.gravityforms.com/u/richardw8k)\ **Post date:** [January 5, 2022, 8:29am UTC](https://community.gravityforms.com/t/from-google-sheets-to-gf/10317/5 "2022-01-05T08:29:23Z")