You should use the API that Google has provided.
You can do it using Node.js, so you should be able to do it using p5.js too.
I’d start here: https://codelabs.developers.google.com/codelabs/sheets-api/#0
1 Like