I need a PHP script to use the Google Drive API to loop through the folders in a given folder and with the files inside (which will be all Sheets) return the document ID and the Sheet content, ideally as JSON.
The folder structure looks like this:
1 /
Sheet1
Sheet2
...
2 /
Sheet1
Sheet2
...
...
and I would want something like this returned:
{ 1: {
1: {awsefflsfiefjfofeofjfeoeffhofeofefepsof:[sheet content as json]
2: {awsefflsfiefjfofeofjfeoeffhofeofefepsof:[sheet content as json]
...
} 2: {
1: {awsefflsfiefjfofeofjfeoeffhofeofefepsof:[sheet content as json]
2: {awsefflsfiefjfofeofjfeoeffhofeofefepsof:[sheet content as json]
...
}
....
}
Hi. I understand that you want to get the contents of your sheets as a JSON by using Google Drive API.
I am a PHP expert and I am experienced with Google Drive API. I can get the data from your spreadsheets and return them all as JSON. If you send me a PM we can talk about the details.
£120 GBP in 4 days
5.0 (34 reviews)
5.2
5.2
9 freelancers are bidding on average £183 GBP for this job
I understand that you need a PHP script that returns the document ID with the sheet content in JSON format. I am capable of doing this. I put my bid low because I have just created my account. Thus, I need references. Please send a PM for details.