Quickstart: Neptyne in Google Sheets

This tutorial shows you how to get quickly up and running with Neptyne in Google Sheets. You'll need access to Google Sheets and the Neptyne Add-on, of course, but once you have that, it shouldn't take you more than 5 minutes to have your first Python code up and running in Google Sheets.

To begin, install the Neptyne: Python for Google Sheets extension, then return here.

Follow the steps below to start using it:

  • Create a new Google Sheet
  • In the toolbar on your sheet, click Extensions > Neptyne: Python for Sheets > Show Code Editor

    Note: It may take a minute or two for the extension to appear here. Try refreshing the page if it doesn't.
  • Paste this python function into your editor on the top of the sidebar
def say_hello(to_who):
    return "hello " + (to_who or "world")
  • In the Python REPL at the bottom of the sidebar, test your function by typing: say_hello("world")
  • In A1, put the value world
  • Now, we will use Neptyne's PY formula to call our Python function say_hello on the value in A1
  • In B1’s formula, type: =PY("say_hello", A1)
  • Change A1 to universe, and notice that B1 re-executes!

Congratulations! You're now you've now integrated Python with your spreadsheet!

Continue to The Magic of Spilling to build your first application!