#googlespreadsheet — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #googlespreadsheet, aggregated by home.social.
-
人生初の副業で、要件定義・スケジュール管理・API申請・本業バッティングに全部やられた話
https://qiita.com/oageST/items/09f4a782cee077000c9e?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items -
JiraとGoogleスプレットシートを連携しプロジェクト横断型のガントチャートを作成してみた
https://qiita.com/sasajimay/items/1dfff3f56739e74033d9?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items -
体調報告忘れてない？～ChatGPTと共にGAS初心者が挑む！毎朝のルーティンにアプローチ！～
https://qiita.com/kinta5960/items/ab49180aa846d0c7bb4e?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items#qiita #GoogleAppsScript #初心者 #GoogleSpreadSheet #GoogleForms #ChatGPT
-
「Free RSS notification tool with filters」
——与 #RSS 有关的 #Coding 向 #教程 #分享 #crosspost
-
「Free RSS notification tool with filters」
——与 #RSS 有关的 #Coding 向 #教程 #分享 #crosspost
-
This is such a cool and simple yet brilliant little template!
Thermometer Goal Setting Template
#edtech #education #template #googlespreadsheet #google #googleworkspace
https://alicekeeler.com/2023/11/07/thermometer-goal-setting-template/
-
This is such a cool and simple yet brilliant little template!
Thermometer Goal Setting Template
#edtech #education #template #googlespreadsheet #google #googleworkspace
https://alicekeeler.com/2023/11/07/thermometer-goal-setting-template/
-
@atomicpoet How about this approach:
1. Question posed in a post (here, blog, etc)
2. Question and Answer placed in a shared spreadsheet (e.g., a #GoogleSpreadsheet due to its open access and connectivity)
3. Webby #KnowledgeGraph generated from spreadsheetWe actually use this approach @openlink and it produces stuff like:
#PostgreSQL #ODBC Driver installation guide: -- https://www.openlinksw.com/describe/?url=http%3A%2F%2Fdata.openlinksw.com%2Foplweb%2Fuda%2Fhowto%2FGenericLinuxLitePostgreSQLPre-installationGuide%23this&invfp=IFP_OFF&sas=SAME_AS_OFF&distinct=1#VirtuosoRDBMS #FAQ -- https://www.openlinksw.com/describe/?url=https%3A%2F%2Fvirtuoso.openlinksw.com%2Ffaq%2F&invfp=IFP_OFF&sas=SAME_AS_OFF&graph=http%3A%2F%2Fwww.openlinksw.com%2FDAV%2Fvirtuoso2.openlinksw.com%2Fdata%2Fturtle%2Fgeneral%2Fvirtuoso-faq.ttl&distinct=1
-
@atomicpoet How about this approach:
1. Question posed in a post (here, blog, etc)
2. Question and Answer placed in a shared spreadsheet (e.g., a #GoogleSpreadsheet due to its open access and connectivity)
3. Webby #KnowledgeGraph generated from spreadsheetWe actually use this approach @openlink and it produces stuff like:
#PostgreSQL #ODBC Driver installation guide: -- https://www.openlinksw.com/describe/?url=http%3A%2F%2Fdata.openlinksw.com%2Foplweb%2Fuda%2Fhowto%2FGenericLinuxLitePostgreSQLPre-installationGuide%23this&invfp=IFP_OFF&sas=SAME_AS_OFF&distinct=1#VirtuosoRDBMS #FAQ -- https://www.openlinksw.com/describe/?url=https%3A%2F%2Fvirtuoso.openlinksw.com%2Ffaq%2F&invfp=IFP_OFF&sas=SAME_AS_OFF&graph=http%3A%2F%2Fwww.openlinksw.com%2FDAV%2Fvirtuoso2.openlinksw.com%2Fdata%2Fturtle%2Fgeneral%2Fvirtuoso-faq.ttl&distinct=1
-
Here is a continuously updated #GoogleSpreadsheet with an actual state of each 3rd party #Twitter client status, in response to recent #API usage issues.
https://docs.google.com/spreadsheets/d/1O27Co27g2fWRon7gK79R8e4th6Xtort3bm289_2jhjQ -
Here is a continuously updated #GoogleSpreadsheet with an actual state of each 3rd party #Twitter client status, in response to recent #API usage issues.
https://docs.google.com/spreadsheets/d/1O27Co27g2fWRon7gK79R8e4th6Xtort3bm289_2jhjQ -
There's a workaround, that reiterates the power of open standards as demonstrated by the awesome #HTTP protocol that goes as follows:
1. Use the "Get Link to Range" feature to generate a URL for a range of cells
2. Make an HTTP GET request using a URL that includes a parameter that indicates format preferences e.g. #CSV.Example:
Given the #GoogleSpreadsheet at:
https://docs.google.com/spreadsheets/d/18Pi1AeQezbTdjjPcb6ol0Rxwx-hq5JkA4RoPsTapPqw/edit#gid=1449881487&sheet=ConsolidatedFollows. -
There's a workaround, that reiterates the power of open standards as demonstrated by the awesome #HTTP protocol that goes as follows:
1. Use the "Get Link to Range" feature to generate a URL for a range of cells
2. Make an HTTP GET request using a URL that includes a parameter that indicates format preferences e.g. #CSV.Example:
Given the #GoogleSpreadsheet at:
https://docs.google.com/spreadsheets/d/18Pi1AeQezbTdjjPcb6ol0Rxwx-hq5JkA4RoPsTapPqw/edit#gid=1449881487&sheet=ConsolidatedFollows. -
I would hope an ability to query your #RSS and #OPML feeds directly using Text Search, #SQL, #GraphSQL, or #SPARQL would fit that bill re data flow and connectivity :)
Audience?
End-users, power-users, and developers who are happy to work with a #Hyperlink as a Data Source Name (#DSN).App Examples?
1. Spreadsheets (#GoogleSpreadsheet, #Excel, #Airtable)
2. Various notebooks (#Jupyter, #Observablehq etc..)
3. Data Visualization Tools
4. Content Management
5. etc/cc @judell
-
I would hope an ability to query your #RSS and #OPML feeds directly using Text Search, #SQL, #GraphSQL, or #SPARQL would fit that bill re data flow and connectivity :)
Audience?
End-users, power-users, and developers who are happy to work with a #Hyperlink as a Data Source Name (#DSN).App Examples?
1. Spreadsheets (#GoogleSpreadsheet, #Excel, #Airtable)
2. Various notebooks (#Jupyter, #Observablehq etc..)
3. Data Visualization Tools
4. Content Management
5. etc/cc @judell
-
Yes!
BTW -- using an #HTTP-based #Hyperlink as an Entity Name addresses the concerns you've raised.
Thanks to the #Fediverse, the power of hyperlink-base entity names will become increasingly obvious, as hashtags demonstrate right now 😀
Here's a publicly accessible #GoogleSpreadsheet that demonstrates hyperlink-based unambiguous entity names (a/k/a #WebID).
-
Yes!
BTW -- using an #HTTP-based #Hyperlink as an Entity Name addresses the concerns you've raised.
Thanks to the #Fediverse, the power of hyperlink-base entity names will become increasingly obvious, as hashtags demonstrate right now 😀
Here's a publicly accessible #GoogleSpreadsheet that demonstrates hyperlink-based unambiguous entity names (a/k/a #WebID).
-
Here's a really neat @observablehq notebook (by @mauforonda ) for exploring @Mastodon follow-networks.
https://observablehq.com/@mauforonda/who-to-follow-on-mastodon
By offering a #CSV export option it simplifies the process of creating a shared #GoogleSpreadsheet rendition which is also a one-click journey to a #KnowledgeGraph.
/cc @judell
-
Here's a really neat @observablehq notebook (by @mauforonda ) for exploring @Mastodon follow-networks.
https://observablehq.com/@mauforonda/who-to-follow-on-mastodon
By offering a #CSV export option it simplifies the process of creating a shared #GoogleSpreadsheet rendition which is also a one-click journey to a #KnowledgeGraph.
/cc @judell
-
Great, I'll take a look.
I use the #GoogleSpreadsheet as an open #database from which various renditions can be generated e.g., a highly discoverable, navigable, declarative query language friendly #KnowledgeGraph etc 😀
-
Great, I'll take a look.
I use the #GoogleSpreadsheet as an open #database from which various renditions can be generated e.g., a highly discoverable, navigable, declarative query language friendly #KnowledgeGraph etc 😀
-
As a baseline for the #CSV exported, shouldn't it mirror what's currently displayed re column names?
I ask because the download I have only includes: Address, Show Boosts, Notify on new Posts, Languages.
I am interested in building a @Mastodon accounts #KnowledgeGraph from this kind of CSV output.
See my publicly shared #GoogleSpreadsheet to get a feel for what I am doing.
/cc @judell
-
As a baseline for the #CSV exported, shouldn't it mirror what's currently displayed re column names?
I ask because the download I have only includes: Address, Show Boosts, Notify on new Posts, Languages.
I am interested in building a @Mastodon accounts #KnowledgeGraph from this kind of CSV output.
See my publicly shared #GoogleSpreadsheet to get a feel for what I am doing.
/cc @judell
-
#URL that denotes a #CSV rendition of the #GoogleSpreadsheet hosted #Database.
URL for generating a #KnowledgeGraph directly from the CSV link above.
URL for exploring Knowledge Graph:
https://linkeddata.uriburner.com/describe/?uri=https%3A%2F%2Flinkeddata.uriburner.com%2Fabout%2Fid%2Fentity%2Fhttps%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1AzZKVS5v9_QA-UHObtVjknaBR1sRVO7d1xx44NeXios%2Fgviz%2Ftq%3Ftqx%3Dout%3Acsv%26range%3DA2%3AE108%26sheet%3DAwesomeCollectionFromGithubURL for page that describes an Ontology automatically derived from the CSV data:
URL that denotes page about a specific item from the Awesome-nostr.
-
#URL that denotes a #CSV rendition of the #GoogleSpreadsheet hosted #Database.
URL for generating a #KnowledgeGraph directly from the CSV link above.
URL for exploring Knowledge Graph:
https://linkeddata.uriburner.com/describe/?uri=https%3A%2F%2Flinkeddata.uriburner.com%2Fabout%2Fid%2Fentity%2Fhttps%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1AzZKVS5v9_QA-UHObtVjknaBR1sRVO7d1xx44NeXios%2Fgviz%2Ftq%3Ftqx%3Dout%3Acsv%26range%3DA2%3AE108%26sheet%3DAwesomeCollectionFromGithubURL for page that describes an Ontology automatically derived from the CSV data:
URL that denotes page about a specific item from the Awesome-nostr.
-
Courtesy of #XSLT, #HTML Tidy, and #TSV output, here's a #Database published via a #GoogleSpreadsheet at:
The source content is from the Awesome #nostr portal on #Github: https://github.com/aljazceru/awesome-nostr.
/cc @melvincarvalho
-
Courtesy of #XSLT, #HTML Tidy, and #TSV output, here's a #Database published via a #GoogleSpreadsheet at:
The source content is from the Awesome #nostr portal on #Github: https://github.com/aljazceru/awesome-nostr.
/cc @melvincarvalho
-
I have a #GoogleSpreadsheet based database at:
https://docs.google.com/spreadsheets/d/18Pi1AeQezbTdjjPcb6ol0Rxwx-hq5JkA4RoPsTapPqw/edit#gid=2069391068&range=A1You can request write privileges if you want to assist with curation etc..
/cc @Mastodon
-
I have a #GoogleSpreadsheet based database at:
https://docs.google.com/spreadsheets/d/18Pi1AeQezbTdjjPcb6ol0Rxwx-hq5JkA4RoPsTapPqw/edit#gid=2069391068&range=A1You can request write privileges if you want to assist with curation etc..
/cc @Mastodon
-
To generate a #KnowledgeGraph directly from a #CSV rendition of the #GoogleSpreadsheet, use the following #URL:
And then click on the value of the "mainEntity" property to start exploration.
-
To generate a #KnowledgeGraph directly from a #CSV rendition of the #GoogleSpreadsheet, use the following #URL:
And then click on the value of the "mainEntity" property to start exploration.
-
To obtain the content of the #GoogleSpreadsheet hosted #database, in #CSV format, you can issue the following #HTTP request.
-
To obtain the content of the #GoogleSpreadsheet hosted #database, in #CSV format, you can issue the following #HTTP request.
-
Delightful Fediverse Apps is a cool collection of #fediverse apps and services published to a #github repo at:
https://codeberg.org/fediverse/delightful-fediverse-apps
Here's a publicly accessible #GoogleSpreadsheet hosted #database generated from the repo that provides an alternative data view.
-
Delightful Fediverse Apps is a cool collection of #fediverse apps and services published to a #github repo at:
https://codeberg.org/fediverse/delightful-fediverse-apps
Here's a publicly accessible #GoogleSpreadsheet hosted #database generated from the repo that provides an alternative data view.
-
Since appending ".rss" to a @Mastodon hashtag search results page offers an #RSS rendition, one can also query directly from RSS-aware clients such as our #VirtuosoRDBMS.
Examples using #SPARQL.
1. https://tinyurl.com/2p88x3fw -- schema.org scoped
2. https://tinyurl.com/2p9bcdfb -- general
Notes:
1. you can decompose query url to see its constituent parts
2. use the results HTML table for #GoogleSpreadsheet import using importHtml() function
3. alter results format e.g., prefer #CSV etc.. -
Since appending ".rss" to a @Mastodon hashtag search results page offers an #RSS rendition, one can also query directly from RSS-aware clients such as our #VirtuosoRDBMS.
Examples using #SPARQL.
1. https://tinyurl.com/2p88x3fw -- schema.org scoped
2. https://tinyurl.com/2p9bcdfb -- general
Notes:
1. you can decompose query url to see its constituent parts
2. use the results HTML table for #GoogleSpreadsheet import using importHtml() function
3. alter results format e.g., prefer #CSV etc.. -
Extending my #GoogleSpreadsheet based #Database with new tabs per additional data source related to
#Mastodon accounts.Naturally, that #spreadsheet will also double as foundation for #KnowledgeGraph generation that supports #SQL, #GraphQL and #SPARQL access.
Note the new #Wikidata tab!
Related:
* https://mastodon.social/@kidehen/109433572843306509 -- initial spreadsheet (derived from original by @dougholton)
* https://mastodon.social/@kidehen/109435758466961883 -- new data from Wikidata (derived from @egonw's query collection)
-
Extending my #GoogleSpreadsheet based #Database with new tabs per additional data source related to
#Mastodon accounts.Naturally, that #spreadsheet will also double as foundation for #KnowledgeGraph generation that supports #SQL, #GraphQL and #SPARQL access.
Note the new #Wikidata tab!
Related:
* https://mastodon.social/@kidehen/109433572843306509 -- initial spreadsheet (derived from original by @dougholton)
* https://mastodon.social/@kidehen/109435758466961883 -- new data from Wikidata (derived from @egonw's query collection)
-
Here's a rendition of your #GoogleSpreadsheet comprising a few #database centric tweaks 😀
https://docs.google.com/spreadsheets/d/18Pi1AeQezbTdjjPcb6ol0Rxwx-hq5JkA4RoPsTapPqw/edit?usp=sharing
Benefits?
Easier to transform into a relational table via the #CSV export option (e.g., https://docs.google.com/spreadsheets/d/18Pi1AeQezbTdjjPcb6ol0Rxwx-hq5JkA4RoPsTapPqw/gviz/tq?tqx=out:csv&range=A1:J413) .
Also easier to transform into a webby #KnowledgeGraph.
-
Here's a rendition of your #GoogleSpreadsheet comprising a few #database centric tweaks 😀
https://docs.google.com/spreadsheets/d/18Pi1AeQezbTdjjPcb6ol0Rxwx-hq5JkA4RoPsTapPqw/edit?usp=sharing
Benefits?
Easier to transform into a relational table via the #CSV export option (e.g., https://docs.google.com/spreadsheets/d/18Pi1AeQezbTdjjPcb6ol0Rxwx-hq5JkA4RoPsTapPqw/gviz/tq?tqx=out:csv&range=A1:J413) .
Also easier to transform into a webby #KnowledgeGraph.
-
The following also resolves to a page comprising an HTML Table that isn't readable via the ImportHtml() provided by #GoogleSpreadsheet for accessing Tables.
-
The following also resolves to a page comprising an HTML Table that isn't readable via the ImportHtml() provided by #GoogleSpreadsheet for accessing Tables.
-
This is really cool!
BTW -- is it possible for you to include #URLs for #JSON and #CSV that resolve directly?
Currently, I am getting the following:
1. cURL against CSV link -- https://tinyurl.com/fe5ss26a
2. cURL against JSON link -- https://tinyurl.com/4d58k5sw
Also, it would help in HTML Table is usable from ImportHtml() in a #GoogleSpreadsheet :)
-
This is really cool!
BTW -- is it possible for you to include #URLs for #JSON and #CSV that resolve directly?
Currently, I am getting the following:
1. cURL against CSV link -- https://tinyurl.com/fe5ss26a
2. cURL against JSON link -- https://tinyurl.com/4d58k5sw
Also, it would help in HTML Table is usable from ImportHtml() in a #GoogleSpreadsheet :)
-
This dashboard would benefit from the following:
1. #CSV output option (possibly via content-negotiation for redirection from main doc #URL)
2. #HTML table construction that's readable by the #GoogleSpreadsheet ImportHtml() function
Once in place, lifting data from the dashboard would be easier for a broad spectrum of #HTTP clients :)
-
This dashboard would benefit from the following:
1. #CSV output option (possibly via content-negotiation for redirection from main doc #URL)
2. #HTML table construction that's readable by the #GoogleSpreadsheet ImportHtml() function
Once in place, lifting data from the dashboard would be easier for a broad spectrum of #HTTP clients :)