Skip to content
Navigation menu
Search
Search
Log in
Create account
DEV Community
Close
#
googlesheets
Follow
Hide
Posts
Left menu
👋
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
How to Use Google Sheets as a Database (Responsibly)
Jacob Lee
Jacob Lee
Jacob Lee
Follow
Oct 7 '20
How to Use Google Sheets as a Database (Responsibly)
#
googlesheets
#
database
#
api
#
autocode
374
reactions
Comments
21
comments
7 min read
Google Sheets as your web backend
Sarthak Ganguly
Sarthak Ganguly
Sarthak Ganguly
Follow
Dec 16 '19
Google Sheets as your web backend
#
googlesheets
#
database
#
cms
#
javascript
143
reactions
Comments
10
comments
7 min read
Website Status Check
nightwolfdev
nightwolfdev
nightwolfdev
Follow
Jan 1 '21
Website Status Check
#
googleappsscript
#
googlesheets
#
javascript
103
reactions
Comments
7
comments
6 min read
Build a custom Contact Form for your static website
Milan Maharjan
Milan Maharjan
Milan Maharjan
Follow
Apr 12 '20
Build a custom Contact Form for your static website
#
javascript
#
html
#
css
#
googlesheets
80
reactions
Comments
9
comments
4 min read
How-to Read & Write Google Sheets with React
CP
CP
CP
Follow
Jun 16 '20
How-to Read & Write Google Sheets with React
#
googlesheets
#
react
#
glideapp
#
javascript
75
reactions
Comments
27
comments
3 min read
How to read or modify spreadsheets from Google Sheets using Node.js ?
Mandeep Singh Gulati
Mandeep Singh Gulati
Mandeep Singh Gulati
Follow
Sep 25 '19
How to read or modify spreadsheets from Google Sheets using Node.js ?
#
googleapi
#
node
#
googlesheets
14
reactions
Comments
Add Comment
10 min read
Natively embed Google Forms in your website
ninest
ninest
ninest
Follow
Aug 3 '20
Natively embed Google Forms in your website
#
form
#
googleforms
#
googlesheets
12
reactions
Comments
2
comments
7 min read
How to sync data between Coda docs (and Google Sheets) using Google Apps Script
Al Chen
Al Chen
Al Chen
Follow
for
Coda
May 21 '19
How to sync data between Coda docs (and Google Sheets) using Google Apps Script
#
productivity
#
javascript
#
googlesheets
#
googleappsscript
12
reactions
Comments
Add Comment
17 min read
Exporting Pandas DataFrames to Google Sheets
Maria Clara Santana
Maria Clara Santana
Maria Clara Santana
Follow
Apr 6 '20
Exporting Pandas DataFrames to Google Sheets
#
python
#
pandas
#
datascience
#
googlesheets
12
reactions
Comments
1
comment
3 min read
Webscraping in Google Sheets (to do personal finance)
milktea02
milktea02
milktea02
Follow
Apr 1 '22
Webscraping in Google Sheets (to do personal finance)
#
googlesheets
#
webscraping
#
finance
#
xquery
11
reactions
Comments
Add Comment
4 min read
Apps Script + REST APIs + Google Sheets + Glide Apps
Harish Kotra (he/him)
Harish Kotra (he/him)
Harish Kotra (he/him)
Follow
Jul 13 '20
Apps Script + REST APIs + Google Sheets + Glide Apps
#
nocode
#
appsscript
#
glide
#
googlesheets
11
reactions
Comments
2
comments
2 min read
Telegram bot + GoogleSheets: solving some problems
Boris Baublys
Boris Baublys
Boris Baublys
Follow
May 7 '22
Telegram bot + GoogleSheets: solving some problems
#
googleappsscript
#
telegram
#
googlesheets
#
bot
11
reactions
Comments
Add Comment
8 min read
Cómo exportar JSON desde Google Sheets
David Daza
David Daza
David Daza
Follow
May 1 '20
Cómo exportar JSON desde Google Sheets
#
json
#
googlesheets
#
googleappsscript
10
reactions
Comments
1
comment
5 min read
Build a resource dashboard with Google Sheets
Domenik Reitzner
Domenik Reitzner
Domenik Reitzner
Follow
Jun 8 '20
Build a resource dashboard with Google Sheets
#
node
#
javascript
#
dashboard
#
googlesheets
9
reactions
Comments
Add Comment
3 min read
How to connect Whatsapp with google sheets?
Arpit Vasani
Arpit Vasani
Arpit Vasani
Follow
Mar 5 '22
How to connect Whatsapp with google sheets?
#
whatsapp
#
googlesheets
#
integration
#
howto
9
reactions
Comments
5
comments
5 min read
Sending Group Notifications with Google Sheets and Node-RED
Julia Biro
Julia Biro
Julia Biro
Follow
for
Vonage
Mar 6 '20
Sending Group Notifications with Google Sheets and Node-RED
#
googlesheets
#
node
#
nodered
#
tutorial
9
reactions
Comments
Add Comment
13 min read
Move Row on Edit using Google Sheets
nightwolfdev
nightwolfdev
nightwolfdev
Follow
Dec 11 '21
Move Row on Edit using Google Sheets
#
googlesheets
#
googleappsscript
9
reactions
Comments
Add Comment
4 min read
Google Sheets + JS class = DX prototyping dream
Bryan Ollendyke
Bryan Ollendyke
Bryan Ollendyke
Follow
Apr 26 '21
Google Sheets + JS class = DX prototyping dream
#
javascript
#
googlesheets
#
webcomponents
#
dx
8
reactions
Comments
1
comment
3 min read
How Google Sheets and Webhooks made my life easier
Leon Nunes
Leon Nunes
Leon Nunes
Follow
Nov 21 '20
How Google Sheets and Webhooks made my life easier
#
appscript
#
javascript
#
googlecloud
#
googlesheets
8
reactions
Comments
Add Comment
2 min read
How I've been using Google Sheets as a personal assistant
Zeyad Etman
Zeyad Etman
Zeyad Etman
Follow
May 30 '20
How I've been using Google Sheets as a personal assistant
#
productivity
#
programming
#
googlesheets
8
reactions
Comments
1
comment
4 min read
How to sync data from Coda to Google Sheets (and vice versa) with Google Apps Script tutorial
Al Chen
Al Chen
Al Chen
Follow
for
Coda
May 4 '20
How to sync data from Coda to Google Sheets (and vice versa) with Google Apps Script tutorial
#
googlesheets
#
coda
#
googleappsscript
#
tutorial
8
reactions
Comments
Add Comment
31 min read
How to export your data from Google Sheets to JSON
oschertar
oschertar
oschertar
Follow
Sep 9 '22
How to export your data from Google Sheets to JSON
#
json
#
javascript
#
googlesheets
#
webdev
8
reactions
Comments
2
comments
2 min read
Running Google Apps Script functions in the background, Part 2
Bruce Axtens
Bruce Axtens
Bruce Axtens
Follow
Sep 13 '19
Running Google Apps Script functions in the background, Part 2
#
javascript
#
googleappsscript
#
googlesheets
8
reactions
Comments
Add Comment
2 min read
Connect Google Sheets with 3rd Party API Using Apps Script
Sagun Shrestha
Sagun Shrestha
Sagun Shrestha
Follow
Jul 23 '20
Connect Google Sheets with 3rd Party API Using Apps Script
#
appsscript
#
googlesheets
#
api
#
tutorial
8
reactions
Comments
2
comments
5 min read
Join data from Google Sheets API and Postgres using Hasura Remote Joins
Hasura
Hasura
Hasura
Follow
for
Hasura
Dec 23 '19
Join data from Google Sheets API and Postgres using Hasura Remote Joins
#
hasura
#
remotejoins
#
googlesheets
#
graphql
7
reactions
Comments
Add Comment
3 min read
How we use Google Sheets API to Manage Our Notification Banners
Joseph Matthias Goh
Joseph Matthias Goh
Joseph Matthias Goh
Follow
for
MyCareersFuture
Apr 24 '20
How we use Google Sheets API to Manage Our Notification Banners
#
api
#
googlesheets
#
business
#
architecture
7
reactions
Comments
Add Comment
7 min read
HOW TO: Google Sheets and Apps Script for time management
Danko
Danko
Danko
Follow
May 29 '21
HOW TO: Google Sheets and Apps Script for time management
#
tutorial
#
javascript
#
appscript
#
googlesheets
7
reactions
Comments
Add Comment
3 min read
Google Sheets to track Dividends (How I pack and search the data after webscraping it)
milktea02
milktea02
milktea02
Follow
Apr 8 '22
Google Sheets to track Dividends (How I pack and search the data after webscraping it)
#
googlesheets
#
webscraping
#
finance
#
dividends
7
reactions
Comments
1
comment
5 min read
How To Import JSON In Google Sheets (With & Without Code)
Meelad Mashaw
Meelad Mashaw
Meelad Mashaw
Follow
Mar 28 '20
How To Import JSON In Google Sheets (With & Without Code)
#
googlesheets
#
googleappsscript
#
api
#
dataanalysis
7
reactions
Comments
1
comment
3 min read
How to bulk-shorten urls in Google Sheets using Google Apps Scripts - a step by step tutorial
Azzouz
Azzouz
Azzouz
Follow
Jan 14 '21
How to bulk-shorten urls in Google Sheets using Google Apps Scripts - a step by step tutorial
#
webdev
#
googleappsscripts
#
googlesheets
#
javascript
6
reactions
Comments
2
comments
1 min read
REP and almost L in Google Apps Script
Bruce Axtens
Bruce Axtens
Bruce Axtens
Follow
Jul 11 '19
REP and almost L in Google Apps Script
#
googleappsscript
#
javascript
#
googlesheets
6
reactions
Comments
Add Comment
2 min read
ScriptProperties Gotcha in Google Apps Script
Bruce Axtens
Bruce Axtens
Bruce Axtens
Follow
Jul 16 '19
ScriptProperties Gotcha in Google Apps Script
#
googleappsscript
#
javascript
#
googlesheets
#
googledocs
6
reactions
Comments
Add Comment
1 min read
Sheets-based Computer Aided Software Development (CASD) #1
Bruce Axtens
Bruce Axtens
Bruce Axtens
Follow
Aug 7 '19
Sheets-based Computer Aided Software Development (CASD) #1
#
programming
#
googlesheets
#
googleappsscript
#
javascript
6
reactions
Comments
Add Comment
2 min read
Help with Google Sheets Script for Parsing JavaScript Objects
Alex Quasar
Alex Quasar
Alex Quasar
Follow
Mar 13 '20
Help with Google Sheets Script for Parsing JavaScript Objects
#
help
#
javascript
#
googlesheets
6
reactions
Comments
Add Comment
2 min read
Create a Custom Function in Google Sheets
nightwolfdev
nightwolfdev
nightwolfdev
Follow
Jan 4 '21
Create a Custom Function in Google Sheets
#
googleappsscript
#
googlesheets
#
javascript
6
reactions
Comments
Add Comment
2 min read
Creating triggers for n8n workflows using polling ⏲
Harshil Agrawal
Harshil Agrawal
Harshil Agrawal
Follow
for
n8n
Jan 14 '21
Creating triggers for n8n workflows using polling ⏲
#
googlesheets
#
mattermost
#
automation
#
polling
6
reactions
Comments
Add Comment
10 min read
Export Mi Band 5 data from Mi Fit to Google Sheets
G Oh
G Oh
G Oh
Follow
Jan 26 '21
Export Mi Band 5 data from Mi Fit to Google Sheets
#
javascript
#
googleappsscript
#
gas
#
googlesheets
6
reactions
Comments
6
comments
3 min read
Simple way to transform any Google Sheet to JSON
Krzysztof Kopieczek
Krzysztof Kopieczek
Krzysztof Kopieczek
Follow
Apr 23 '21
Simple way to transform any Google Sheet to JSON
#
5days5blogposts
#
googlesheets
#
csharp
#
json
6
reactions
Comments
Add Comment
2 min read
Air Quality - Pollutant Index - India
Adhir Kirtikar
Adhir Kirtikar
Adhir Kirtikar
Follow
Nov 24 '21
Air Quality - Pollutant Index - India
#
actionshackathon21
#
python
#
googlesheets
#
tableau
6
reactions
Comments
Add Comment
3 min read
Google Sheets setValues anomaly?
Bruce Axtens
Bruce Axtens
Bruce Axtens
Follow
Apr 14 '22
Google Sheets setValues anomaly?
#
javascript
#
googleappsscript
#
googlesheets
6
reactions
Comments
Add Comment
1 min read
Populate and Filter Dates Between Start/End Dates in Google Sheets
nightwolfdev
nightwolfdev
nightwolfdev
Follow
May 17 '22
Populate and Filter Dates Between Start/End Dates in Google Sheets
#
googlesheets
6
reactions
Comments
Add Comment
3 min read
Automatio + SpreadSheet + ChatGPT = 👌
Moon.ly
Moon.ly
Moon.ly
Follow
Sep 28 '23
Automatio + SpreadSheet + ChatGPT = 👌
#
automation
#
webscraping
#
chatgpt
#
googlesheets
6
reactions
Comments
1
comment
2 min read
How to monetize your Google Workspace add-on?
Corentin
Corentin
Corentin
Follow
Nov 6 '22
How to monetize your Google Workspace add-on?
#
tutorial
#
googleworkspace
#
googlesheets
#
gmail
5
reactions
Comments
Add Comment
7 min read
Automate Form Submission: ChatGPT-Powered Bot with Google Sheet Integration via Automatio 🤖
Moon.ly
Moon.ly
Moon.ly
Follow
Oct 16 '23
Automate Form Submission: ChatGPT-Powered Bot with Google Sheet Integration via Automatio 🤖
#
webscraping
#
automation
#
chatgpt
#
googlesheets
5
reactions
Comments
Add Comment
2 min read
How to convert column index of a spreadsheet into letters
All Stacks Developer
All Stacks Developer
All Stacks Developer
Follow
Jan 25 '22
How to convert column index of a spreadsheet into letters
#
showdev
#
googlesheets
#
javascript
5
reactions
Comments
Add Comment
5 min read
Create personal stock portfolio tracker with Google Sheets and Google Data Studio
All Stacks Developer
All Stacks Developer
All Stacks Developer
Follow
Jul 10 '21
Create personal stock portfolio tracker with Google Sheets and Google Data Studio
#
showdev
#
appscript
#
googlesheets
#
googledatastudio
5
reactions
Comments
1
comment
2 min read
Create Dividend Tracker With Google Sheets
All Stacks Developer
All Stacks Developer
All Stacks Developer
Follow
Nov 23 '21
Create Dividend Tracker With Google Sheets
#
showdev
#
googlesheets
#
javascript
5
reactions
Comments
2
comments
1 min read
Tutorial: Getting real-time currency data in Google Sheets
Elli
Elli
Elli
Follow
Mar 30 '22
Tutorial: Getting real-time currency data in Google Sheets
#
tutorial
#
googlesheets
#
currencydata
#
spreadsheets
4
reactions
Comments
Add Comment
4 min read
Create a Powerful Google Sheets Dashboard with DronaHQ
Aaikansh Agrawal
Aaikansh Agrawal
Aaikansh Agrawal
Follow
for
DronaHQ
Nov 24 '22
Create a Powerful Google Sheets Dashboard with DronaHQ
#
lowcode
#
dashboard
#
googlesheets
#
tutorial
4
reactions
Comments
Add Comment
6 min read
Make any JavaScript method available in Google Sheets
All Stacks Developer
All Stacks Developer
All Stacks Developer
Follow
Sep 30 '22
Make any JavaScript method available in Google Sheets
#
showdev
#
javascript
#
appscript
#
googlesheets
4
reactions
Comments
Add Comment
2 min read
How to send your html form to Google Sheets for free
Franz Rodenacker
Franz Rodenacker
Franz Rodenacker
Follow
May 14 '21
How to send your html form to Google Sheets for free
#
googlesheets
#
forms
#
staticsites
#
googleforms
4
reactions
Comments
2
comments
6 min read
Retrieve datas from postgreSQL to Google Sheets with Heroku for free
Jady Nekena
Jady Nekena
Jady Nekena
Follow
Jun 28 '21
Retrieve datas from postgreSQL to Google Sheets with Heroku for free
#
datas
#
postgres
#
googlesheets
#
heroku
4
reactions
Comments
Add Comment
8 min read
How to Send Google Forms Responses in an Email Automatically?
Nibesh Khadka
Nibesh Khadka
Nibesh Khadka
Follow
Aug 14 '22
How to Send Google Forms Responses in an Email Automatically?
#
javascript
#
appscript
#
googlesheets
#
googleappsscript
4
reactions
Comments
Add Comment
6 min read
Stock correlation analysis with Google Sheets
All Stacks Developer
All Stacks Developer
All Stacks Developer
Follow
Nov 23 '21
Stock correlation analysis with Google Sheets
#
showdev
#
googlesheets
#
javascript
4
reactions
Comments
Add Comment
1 min read
How do I format a column to a specific type of date time in Google Sheet?
Harit Himanshu
Harit Himanshu
Harit Himanshu
Follow
Oct 14 '19
How do I format a column to a specific type of date time in Google Sheet?
#
googlesheets
#
date
#
timezone
4
reactions
Comments
Add Comment
1 min read
Automagically fetching Google Calendar data without OAuth by using Google Scripts
Julien Lengrand-Lambert
Julien Lengrand-Lambert
Julien Lengrand-Lambert
Follow
Feb 1 '21
Automagically fetching Google Calendar data without OAuth by using Google Scripts
#
googlesheets
#
javascript
#
webcomponents
#
googlescripts
4
reactions
Comments
Add Comment
7 min read
Pain points and missing features from Google Sheets
Ansaf Ahmad
Ansaf Ahmad
Ansaf Ahmad
Follow
Aug 13 '22
Pain points and missing features from Google Sheets
#
discuss
#
google
#
googlesheets
#
excel
4
reactions
Comments
Add Comment
1 min read
Show Dev: How I made a SocProof widget for my own site and turn it to profitable side-project
Bootstraptor
Bootstraptor
Bootstraptor
Follow
Jun 26 '20
Show Dev: How I made a SocProof widget for my own site and turn it to profitable side-project
#
showdev
#
googlesheets
#
startup
#
socialproof
3
reactions
Comments
Add Comment
3 min read
With Google Apps Script going to V8, whither ts2gas?
Bruce Axtens
Bruce Axtens
Bruce Axtens
Follow
Apr 25 '20
With Google Apps Script going to V8, whither ts2gas?
#
help
#
googleappsscript
#
javascript
#
googlesheets
3
reactions
Comments
1
comment
1 min read
How to highlight a cell or cells in Google Sheets for a value or given set of values
Abiola Omiyale
Abiola Omiyale
Abiola Omiyale
Follow
Nov 20 '22
How to highlight a cell or cells in Google Sheets for a value or given set of values
#
excel
#
googlesheets
3
reactions
Comments
Add Comment
2 min read
loading...
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account