Google Spreadsheet row insertion example

add_row.sh

# $auth from auth.sh
# $spreadsheet_id from get_spreadsheets.sh
# $worksheet_id from get_worksheets.sh
curl \
  --header "Authorization: GoogleLogin auth=$auth" \
  --header 'Content-Type: application/atom+xml' \
  -d @data.xml \
  -X POST \
  "https://spreadsheets.google.com/feeds/list/$spreadsheet_id/$worksheet_id/private/full"
# Example data in data.xml

auth.sh

curl https://www.google.com/accounts/ClientLogin \
  --data-urlencode Email=$email --data-urlencode Passwd=$password \
  -d accountType=GOOGLE \
  -d source=Google-cURL-Example \
  -d service=wise
# If you have 2-factor auth enabled, you need to create an application password to use here
# Response includes an "Auth=..." line with your token

data.xml

<!--
  Note headers are lowercase. I haven't checked if that matters, but it's how Google response to a GET.
  This schema matches the spreadsheet at https://docs.google.com/spreadsheets/d/1QG5xPBsIy5BHOvMBzgr_iSHAcx24HPgcg_B3GMh3qt4/edit?usp=sharing
  which looks like:
  Fruit | Color | Size
  ====================== <- Header bar in UI; not sure if this matters or if Google uses the first row anyway
  Apple | Red   | Medium
-->
<entry xmlns="http://www.w3.org/2005/Atom"
    xmlns:gsx="http://schemas.google.com/spreadsheets/2006/extended">
  <gsx:fruit>Orange</gsx:fruit>
  <gsx:color>Orange</gsx:color>
  <gsx:size>Medium</gsx:size>
</entry>

get_rows.sh

# $auth from auth.sh
# $spreadsheet_id from get_spreadsheets.sh
# $worksheet_id from get_worksheets.sh
curl \
  --header "Authorization: GoogleLogin auth=$auth" \
  "https://spreadsheets.google.com/feeds/list/$spreadsheet_id/$worksheet_id/private/full"
# Example response data:
# <title type="text">Apple</title>
# <content type="text">color: Red, size: Medium</content>
# <gsx:fruit>Apple</gsx:fruit>
# <gsx:color>Red</gsx:color>
# <gsx:size>Medium</gsx:size>

get_spreadsheets.sh

# $auth from auth.sh on the line reading Auth=...
curl \
  --header "Authorization: GoogleLogin auth=$auth" \
  "https://spreadsheets.google.com/feeds/spreadsheets/private/full"
# Look in this response for your spreadsheet ID / worksheet fetch URL in the <link rel="...#worksheetsfeed" href="..." />
# Example spreadsheet: https://docs.google.com/spreadsheets/d/1QG5xPBsIy5BHOvMBzgr_iSHAcx24HPgcg_B3GMh3qt4/edit?usp=sharing
# GET response: <link rel="http://schemas.google.com/spreadsheets/2006#worksheetsfeed" type="application/atom+xml" href="https://spreadsheets.google.com/feeds/worksheets/1QG5xPBsIy5BHOvMBzgr_iSHAcx24HPgcg_B3GMh3qt4/private/full"/>

get_worksheets.sh

# URL / $spreadsheet_id from get_spreadsheets.sh
curl \
  --header "Authorization: GoogleLogin auth=$auth" \
  "https://spreadsheets.google.com/feeds/worksheets/$spreadsheet_id/private/full"
# Look for your worksheet ID / rows URL in <link rel="...#listfeed" href="..." />
# Eg, this shows worksheet ID "od6"
# <link rel="http://schemas.google.com/spreadsheets/2006#listfeed" type="application/atom+xml" href="https://spreadsheets.google.com/feeds/list/1QG5xPBsIy5BHOvMBzgr_iSHAcx24HPgcg_B3GMh3qt4/od6/private/full"/>

auth.sh doesn't work anymore.
It returns the URL https://developers.google.com/accounts/docs/AuthForInstalledApps which essentially tells us that this has been deprecated since 2012.