Skip to content
← General

I suggest you ...

General

Categories

(thinking…)

Fetch data from Google Sheets

Simple: specify a particular cell of a particular sheet as an odometer

Sophisticated: specify date and data-value columns from a particular sheet.

3 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Christopher Allen shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Christopher Allen commented  ·   ·  Report

    My 'sophisticated' implementation was along the lines of one-row-per-day, but here's a...

    More sophisticated: specify date, data-value and comment columns from a particular sheet (allow multiple rows per date).

  • Christopher Allen commented  ·   ·  Report

    Motivation: I already track lots of stuff (e.g. pomodoros completed) in Google sheets, and having to manually transcribe data is annoying.

    I gather that I might be able to do this using Zapier, but I aspire to complete more than 100 pomodoros a month so that will get expensive.

    IFTTT ought to be able to do this, but it doesn't seem to be able to trigger based on changes to a sheet (or indeed any other triggers for Google Drive at all).

    It might be possible to do this using Google App Script (to push data to Beeminder), but even if Ap Script will let me connect to external sites (which I am doubtful about) it would still be better to pull data rather than push it.