API to pull from Google sheet

[partialarts]

AS a developer I WANT to import Google Sheet data into a JSON format SO THAT the client can update the site content themselves

• [x] Research Google sheets API
• [x] Query from example dataset
• [x] Store data in JSON format
• [x] Render data onto site

If API doesn't meet requirements:

• [ ] Are there cloud based services that can pull from a Google sheet and store in JSON format
• [ ] Test out this service

Set Up Google Sheets API:

Go to the Google Cloud Console. Create a new project or select an existing one. Enable the Google Sheets API for your project. Create credentials (OAuth client ID) to authenticate your API requests. Install Necessary Libraries:

If you are using a programming language, you might need to install the relevant client library. For example, if you're using Python, you can install the gspread library. Write Code to Fetch Data:

Write code using the Google Sheets API or the client library to fetch data from your Google Sheet. The data can be retrieved in the form of a JSON object.

Google Cloud Console link: https://cloud.google.com/cloud-console/?utm_source=google&utm_medium=cpc&utm_campaign=emea-gb-all-en-dr-bkws-all-all-trial-e-gcp-1707574&utm_content=text-ad-none-any-DEV_c-CRE_574560852474-ADGP_Hybrid%20%7C%20BKWS%20-%20EXA%20%7C%20Txt%20~%20Management%20Tools%20~%20Cloud%20Console%23v1-KWID_43700053285287183-kwd-55675752867-userloc_9045891&utm_term=KW_google%20cloud%20console-NET_g-PLAC_&&gad_source=1&gclid=Cj0KCQiAhomtBhDgARIsABcaYylZmCJZI_cDNxHZyVeVSv8jn9EUkWVvFuuHYTVeweZPcYBtuWFvooMaAkhgEALw_wcB&gclsrc=aw.ds

Resources: https://medium.com/vowel-magic/how-to-fetch-data-from-google-sheets-with-react-and-tabletop-js-ca0e9d2ab34b https://airbyte.com/how-to-sync/google-sheets-to-local-json https://dev.to/calvinpak/how-to-read-write-google-sheets-with-react-193l

[partialarts]

• Tested Papaparse package in browser and installed NPM package. Working OK.

• [ ] - Need to test in React