Jump to content

Introducing gsheets – a Workflow to access Google Sheets


Recommended Posts

Inspired by I-sheet-you-not, this Workflow creates new Workflows to access individual Google Sheets with Alfred.

⬇️Download

 

 

Note: this setup is more complex than the average workflow. I tried to document all the steps, feel free to point to unclear steps or instructions.

A screencast of the process is here.

 

🚀Usage

  1. Open a Google Sheet in your browser. 
  2. Launch alfred-gsheets via keyword (default: gshe) or hotkey
  3. alfred-gsheets will check the frontmost page with one of three outcomes: will check the frontmost page with one of three outcomes:

     

    1. The website is not a Google Sheet ▶️ check URL
    2. The website is a Google Sheet but you don’t have the right permissions ▶️ review the Setting up section
    3. The website is a Google Sheet and you have at least viewing privileges ▶️ go to step 4

     

  4. alfred-gsheets will list the individual worksheets. Select one to generate a alfred-gsheets Workflow instance to browse that Sheet. 

  5. Once a new Workflow is created, ↩️ will lead you to its Workflow Configuration, where changes to keyword etc. can be made:

  • Header Row (column headers). Row containing the column headers. Set this to 0 if no header.[/*]
  • columns for Alfred’s Title (required), Subtitle and Arg variables. 
  • Alternatively, a custom layout can be set as follows: up to three lines (for Title (required), Subtitle and Arg variables), with layout text in quotes and column numbers in square brackets. For example:[/*]
Title: "College 🎓: [1]"
Subtitle: "City: [2]"
Arg: "URL: [3]"

 

  • Note: if a custom layout is used, the Title, Subtitle and Arg fields will be ignored. 
  • Append column: If you have writing privileges on your Google Sheet (see Setting up), you can indicate a column to which append values via alfred-gsheets using a keyword (default: [main workflow keyword]::append, e.g. uni::append) or hotkey[/*]
  • [/list]


🧮 New workflow: usage

  • entering the main keyword (default: first three letters of the workflow name) will list sheet columns according to the Title, Subtitle, and Arg variables.
  • If the argument is a URL, Enter↩️ will open it in your browser. 
  • If not, Enter↩️ will copy it to the clipboard
Edited by giovanni
Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...