Tôi đã bỏ qua toàn bộ Google Cloud Console để xây dựng chức năng theo dõi đăng nhập cho MVP của mình chỉ với 4 dòng code Apps Script. Dùng Google Sheets làm nơi lưu log đăng nhập từ Next.js qua Webhook – không cần xác thực, miễn phí và hoạt động ngay lập tức. Hoàn hảo cho MVP dù không thể scale lớn. Khi nào nên chuyển từ hack MVP sang hạ tầng thật? #MVP #NoCode #SaaS #Startup #Hacking #Dev #KiemTienOnline #CongNghe #AppsScript #GoogleSheets

https://www.reddit.com/r/SaaS/comments/1qof54j/i_bypas

Получить цены акций, фондов и ОФЗ в Google Sheets

Привет, Хабр! Изучая информацию по работе с API в таблицах Google/Excel, понял лишь то, что я ничего не понимаю, разбираться в xpath, в парсинге XML внутри формулы это всё, как-то очень тяжело и громостко. У меня была простая задача, разработать что бы то ни было для получения текущей цены по конкретному активу с Мосбиржи. И как мне кажется, у меня это получилось в дотаточной степени чтобы можно было получить информацию и далее, как-то её агригировать, как вам удобно. Также сразу поясню, что функция GOOGLEFINANCE больше не работает, по этому остается искать другие пути решения.

https://habr.com/ru/articles/964722/

#api #GoogleТаблицы #excel #xpath #json #мосбиржа #appsscript

Получить цены акций, фондов и ОФЗ в Google Sheets

Привет, Хабр! Изучая информацию по работе с API в таблицах Google/Excel, понял лишь одно: я ничего не понимаю. Разбираться в XPath, в парсинге XML внутри формул — это всё как-то слишком сложно и...

Хабр

Introducing the Boot Framework!

In one of my previous posts, I discussed the challenges of routing and the lack of convenient tools within Google Apps Script. But now, that's a thing of the past.

I am thrilled to introduce appsscript-boot, my first framework built specifically for Google Apps Script!

https://github.com/MaksymStoianov/appsscript-boot

#MaksymStoianov #OpenSource #GoogleAppsScript #AppsScript #Library #Framework #JavaScript #TypeScript #GoogleWorkspace #GoogleSheets #GoogleDocs #Coding #Automation

Colleagues, today I'm excited to present my new Open Source utility library for Google Apps Script.

This library is designed to significantly reduce your development time, improve code readability, and allow you to focus on more complex and interesting tasks.

Follow the link, explore the code, and start testing it out!

https://github.com/MaksymStoianov/appsscript-utils

#MaksymStoianov #OpenSource #GoogleAppsScript #AppsScript #Library #JavaScript #TypeScript #GoogleWorkspace #GoogleSheets #GoogleDocs #Coding #Utility

When you build complex applications on Google Apps Script, you quickly run into the challenge of Routing.

Routing is the core mechanism in a web application that determines which code should be executed and what content should be displayed to the user in response to a specific request.

I've detailed the core issue and its nuances in the comments below.

Have you encountered this routing problem, and how did you solve it in your projects?

#MaksymStoianov #GoogleAppsScript #AppsScript

Get an email when your security camera sees something new (Apps Script + Cloud Vision) #code #drive #google #dropcam #nest #appsscript #vision How to use Apps Script and the Google Cloud Vision API to monitor a webcam and send email when it spots something new

https://fed.brid.gy/r/https://ithoughthecamewithyou.com/post/get-an-email-when-your-security-camera-sees-something-new-apps-script--cloud-vision

Get an email when your security camera sees something new (Apps Script + Cloud Vision)

How to use Apps Script and the Google Cloud Vision API to monitor a webcam and send email when it spots something new

I Thought He Came With You

Automate Google PageSpeed Insights and Core Web Vitals Logging with Apps Script #code #google #appsscript #gas #pagespeed How to automatically monitor page load performance using the Google PageSpeed Insights API and Apps Script

https://fed.brid.gy/r/https://ithoughthecamewithyou.com/post/automate-google-pagespeed-insights-with-apps-script

Automate Google PageSpeed Insights and Core Web Vitals Logging with Apps Script

How to automatically monitor page load performance using the Google PageSpeed Insights API and Apps Script

I Thought He Came With You

How to backup Google Photos to Google Drive automatically after July 2019 with Apps Script #code #software #photos #appsscript #google #sheets #drive #api Easy to configure apps script to continue backing up your Google Photos to Google Drive after the July 2019 change. You just need to change two lines of the script to get this running with your Google Photos account.

https://fed.brid.gy/r/https://ithoughthecamewithyou.com/post/how-to-backup-google-photos-to-google-drive-automatically-after-july-2019-with-apps-script

How to backup Google Photos to Google Drive automatically after July 2019 with Apps Script

Easy to configure apps script to continue backing up your Google Photos to Google Drive after the July 2019 change. You just need to change two lines of the script to get this running with your Google Photos account.

I Thought He Came With You

Using the Todoist API to set a due date on the Alexa integration to-do list (with Apps Script) #code #appsscript #google #drive #todoist #productivity Script to fix an annoyance with the Todoist Alexa integration where tasks are added without a due date leading them to be overlooked. Requires Google Drive and Todoist.

https://fed.brid.gy/r/https://ithoughthecamewithyou.com/post/using-the-todoist-api-to-set-a-due-date-on-the-alexa-integration-todo-list-with-apps-script

Using the Todoist API to set a due date on the Alexa integration to-do list (with Apps Script)

Script to fix an annoyance with the Todoist Alexa integration where tasks are added without a due date leading them to be overlooked. Requires Google Drive and Todoist.

I Thought He Came With You

Animation of a year of Global Cloud Cover #code #software #video #animation #appsscript #drive #earth #nasa #xplanet Timelapse video showing cloud cover, day and night and changing seasons. Rendered in Catfood Earth.

https://fed.brid.gy/r/https://ithoughthecamewithyou.com/post/animation-of-a-year-of-global-cloud-cover

Animation of a year of Global Cloud Cover

Timelapse video showing cloud cover, day and night and changing seasons. Rendered in Catfood Earth.

I Thought He Came With You