Need help with Google sheets

With Reference to
I wanted to ask from where can I learn the the scripts , how to write them myself, Any links or examples would be of great help!

Thanks in advance!

There is quite a bit from what we already did, but have a look through this list:

AI2 and Google Drive/Docs/Sheets
HOWTO: Query Any Google Sheet with a Web App.
UPDATED! HOWTO - Upload Any File to Google Drive !
HOWTO: Use AI2 to directly submit Google Form Data
HOWTO: Google Drive - Multiple Files Download (file by file)
HOWTO: Download Google sheet as CSV
HOWTO: Send Data to Google Sheet with Web App
HOWTO: Show Image from Google Drive
HOWTO: Upload Image to Google Drive using base64 and Google Apps Script Web App
HOWTO: Upload Image to Google Drive using base64 using Camera Image
HOWTO: Get Data from Private Google Sheet with A Google WebApp
HOWTO: Get the ID of Image after uploading using base64
HOWTO: Upload CSV or List to Google Sheet
HOWTO: AI2 - Google Sheets - Web App - Create/Read/Update/Delete
HOWTO: OCR Images and Camera Pictures with Google Docs
HOWTO: OCR pdf and image files using Google Docs OCR function
HOWTO: Upload "Any" File to Google Drive
HOWTO: Use google web app and google query to download filtered output as pdf from Google Sheet
HOWTO: Use Ai2 to Delete Images (or other files) on Google Drive
HOWTO: Take Photo, get GPS Location and Address, upload Image to Google Drive, and save Location data to spreadsheet 
HOWTO: Select a Single Row from a Spreadsheet, and howto EDIT that data

and also remember:

1 Open the script project
2 Go to Publish
3 Deploy as Web App
4 Project version: - select New from the dropdown
5 Execute the app as: your google account address (email)
6 Who has access to the app: Anyone, even anonymous
7 Press the Update button

You have to do this EVERY TIME you change your script

With reference to this link:

HOWTO: Query Any Google Sheet with a Web App

function doGet(e) {
  return queryAnySheet(e);
function doPost(e) {
  return queryAnySheet(e);

What are these doPost and doGet functions? here they would trigger the Function queryAnySheet
Are doPost and doGet some specific functions which would Post and Get data or are these just the names given by the user and names can be anything?

another doubt is about e
function doPost (e)
Can it be some other letter? if not what is e 's role?

See here:

I would leave “e” as “e”

1 Like

Thanks for your help!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.