Evapotranspiration Workflow

June 23rd, 2012


How to run this workflow:

  1. open the spreadsheet template: evapo-koogle. The access level of this spreadsheet is “Anyone who has the link may view”.
  2. copy this spreadsheet to your own “Google Documents”: “File” –> “make a copy”; go to your own “Google Documents”.
  3. Find the URL to your own spreadsheet: – “Copy of evapo-koogle”. There are two ways to get the URLs: method A and method B. A couldn’t guarantee to get the correct URL all the time, so method B is recommended
    • A: If no other browser window is opening this spreadsheet, and no other users is viewing this spreadsheet, the URL should be like “https://spreadsheets.google.com/ccc?key=********”. If the URL looks like “https://spreadsheets0.google.com/ccc?key=” or has other numbers following “https://spreadsheets”, try B to get the correct URL
    • B:  click “Share” –> “Sharing settings”, “Permissions” “change”, choose “Anyone with the link”, “save”. A URL will appear in the box of “Paste this link in email or IM:”.  Remove the sub-string starting with “&hl=” to the end of the URL, then it is the URL you need to copy to your workflow. (After URL is acquired, you can change this spreadsheet back to private.) E.g. for the URL you coped from the box: https://spreadsheets.google.com/ccc?key=0AAAAAAAAAAA&hl=en&authkey=CI_1macO, the valid URL part you need for the workflow is: https://spreadsheets.google.com/ccc?key=0AAAAAAAAAAA
  4. copy the URL to “ImportSpreadsheetURL” parameter of the workflow, run it.


video demo on YouTube