Fetch Data from Google Sheet

[mohammed786]

Currently, this portal is fetching the data from the local file, need to add the feature of fetching the data from excel sheet, the fields of sheets can be same as the attributes of a JSON object in the constant.js file.

[utk0730]

Hi Mohammed,
may i work on this issue ?

[mohammed786]

Sure @utk0730 You can take this up.

Also, If you Contribute to LoginRadius Open Source. As part of hacktoberfest, LoginRadius is also giving free swags and goodies to its contributors. Please check out our Hacktoberfest Page and fill the form mentioned there to become eligible for free swags. :)

[utk0730]

So all the files with hardcoded data in constants folder needs to be served from google sheet, let me know if i am right on this.
Approach:

1. reading the different file data into different google sheet by using ImportJson function of google sheet, publish sheet url and call in in front end to fetch data into respective components
2. Not-nested json data seems to be clear approach (people data, talk data, open source data etc)

Suggestion:

How do u suggest me to structure the nested data into google sheet. (example :hackathon data)

[utk0730]

@mohammed786 Let me know your thoughts ⬆️

[mohammed786]

Hey @utk0730 ,

Your approach looks good to me, you can go ahead with the non-nested data, and call the ImportJSON function of google sheet in a front end to fetch the data into the respective component.