0

I am integrating Google Sheets with my Android application. Here is what I need to do, Each and every day I need to put entry to the last column in my spreadsheet. I know there is a simple way in Google Apps Script and my script is:

var ss= SpreadsheetApp.openById(id);
var sheet=ss.getSheetByName("Sheet1");
sheet.getRange(0, sheet.getLastColumn() + 1).setValue(myData);

I need to know if there is a similar way to do this in android(java) other than connecting my android application and this script via HttpURLConnection.

Thanks.

TheMaster
  • 45,448
  • 6
  • 62
  • 85
Surya Elavazhagan
  • 39
  • 4
  • There are [Android Add-ons for Google Docs and Sheets](https://developers.google.com/apps-script/add-ons/mobile/); not sure if that is what you are looking for – random-parts Nov 21 '17 at 23:59
  • Hey thanks! I don't know there is an API to connect with Apps script and mobile apps. But I need to know whether there is a straight way to get my solution. – Surya Elavazhagan Nov 22 '17 at 03:57
  • AFAIK, Google Sheets API and Apps Script works differently from each other. As stated in this related [SO post](https://stackoverflow.com/a/37687676/5995040), they have different style. As a workaround you have to provide the last column/row then count the offset from your requested column/row to get the last column. Hope this helps. – Mr.Rebot Nov 23 '17 at 16:37

0 Answers0