Challenges with Google Sheets "Make an API call"

Questions & Answers
9

So, I finally figured it out. And although I haven’t completed the solution, I solved the Google sheet thing… Thanks @Philippe_Billet and @samliew for trying to help on this!

It turns out some of the settings in the “Make an API Call” were incorrect in the example I was following at Insert multiple rows in Google Spreadsheets from HTTP request that give xml of products

So, these settings worked for me

  • URL = Spreadsheets/SpreadsheetID/values/a:z where Spreadsheet refers to the https://docs.google.com/spreadsheets/d/**SpreadsheetID**/edit#gid=SheetID.
  • Method = PUT not POST per the previous example
  • valueInputOption = User_Entered but will be fiddling with this going further
  • Body is currently {values: [[“Order ID”,“Date”,“SKU”],{{20.text}}]} though am sure that it may not have overly influenced the result/solution to this part of the puzzle.

Thanks to this video for steering me to the final solution.

4 Likes