Google Sheets and Fabrik Forums

[aharbert4019]

Hi Fabrik Community,

My name is Anthony and I work at my local coffee shop.

We are currently working on implemented stat gathering from Google sheets and importing data from said Google Sheets to a Fabrik form. We intend to make this data as live as possible.

My current plan is to implement a separate sheet tab within our Employee main Google sheet that compiles data based on initials (for example if someone baked Cinnamon rolls, they would log the said Rolls in the Sheet with their initials) then outputs a number per month. I can use a simple formula in excel to gather that data but I am unsure of how to import that data into a Fabrik Form.
So far, I can publish the sheet "to the web" where Google Sheets provides me with embed HTML per sheet tab. I am just unsure of how to then use that embed HTML on Fabrik.

Let me know if you need any more details to continue and if you can provide any assistance in our endeavors.

Thank you,

Anthony

 

[cheesegrits]

I don't think the embed HTML is what you need. You'd need to use the Google PHP API, something like this:

https://www.fillup.io/post/read-and-write-google-sheets-from-php/

Nothing about working with Google's APIs in PHP is simple.

-- hugh