Using Google Sheets to Edit Scripts

If you're already using MarinOne Scripts, this article will give you a new way that you can unlock their power using a tool you already have in your tool belt – Google Sheets. Now you can use Google Sheets as a secondary data source for your MarinOne Scripts to create and edit your automated actions. 

You can do so in a few easy steps:

1. In a new or existing Google Sheet, insert the data that you wish to feed the code.  
Note: 

  • The system will assume the first row is the header for the data.
  • All Sheets within Google Sheets would be pulled into Scripts. Each sheet may be referenced as an independent DataFrame in Python.

2. Add marin-scripts-gsheet@marin-scripts.iam.gserviceaccount.com as a viewer. 

3. Add the Google Sheet link as a reference doc in the settings tab for the script and click save to implement the change.

4. The system will run at its scheduled time, but if you want to push an immediate update, you can do so by clicking “Run Now” in the Scheduled Report page.

Written by Kelsey Kamp

Last published at: September 21st, 2023