Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Google Drive API - Update Spreadsheet data

I want to send data from my web application to a google drive spreadsheet, so it will be easier for other people see data. So I have one spreadsheet and I want to add lines to it whenever there is new data.

My question is, is there an option to just add a line to a spreadsheet?

If not, then I suppose the only way to accomplish this is by getting the file, adding the line, and than uploading again?

like image 799
Moshe Shaham Avatar asked Dec 24 '12 08:12

Moshe Shaham


People also ask

Can Google Sheets pull data from an API?

Once you've set up your API to Google Sheets connection, click Save And Run to get data to your spreadsheet.


2 Answers

The Google Drive API is meant for generic file / folder interactions. For directly modifying Google Spreadsheet data, the Google Sheets API would be the better choice.

like image 72
Jay Lee Avatar answered Oct 07 '22 17:10

Jay Lee


Google Docs API is no longer supported use Google Drive API https://developers.google.com/drive/v2/reference/files/update

Please check Changes to deprecation policies and API spring cleaning

like image 24
Mohamed Alaa Avatar answered Oct 07 '22 15:10

Mohamed Alaa