#appsscript — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #appsscript, aggregated by home.social.
-
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
-
Получить цены акций, фондов и ОФЗ в 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 внутри формулы это всё, как-то очень тяжело и громостко. У меня была простая задача, разработать что бы то ни было для получения текущей цены по конкретному активу с Мосбиржи. И как мне кажется, у меня это получилось в дотаточной степени чтобы можно было получить информацию и далее, как-то её агригировать, как вам удобно. Также сразу поясню, что функция GOOGLEFINANCE больше не работает, по этому остается искать другие пути решения.
https://habr.com/ru/articles/964722/
#api #GoogleТаблицы #excel #xpath #json #мосбиржа #appsscript
-
Получить цены акций, фондов и ОФЗ в 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 внутри формулы это всё, как-то очень тяжело и громостко. У меня была простая задача, разработать что бы то ни было для получения текущей цены по конкретному активу с Мосбиржи. И как мне кажется, у меня это получилось в дотаточной степени чтобы можно было получить информацию и далее, как-то её агригировать, как вам удобно. Также сразу поясню, что функция GOOGLEFINANCE больше не работает, по этому остается искать другие пути решения.
https://habr.com/ru/articles/964722/
#api #GoogleТаблицы #excel #xpath #json #мосбиржа #appsscript
-
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
-
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
-
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://ithoughthecamewithyou.com/post/automate-google-pagespeed-insights-with-apps-script
-
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://ithoughthecamewithyou.com/post/automate-google-pagespeed-insights-with-apps-script
-
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://ithoughthecamewithyou.com/post/automate-google-pagespeed-insights-with-apps-script
-
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://ithoughthecamewithyou.com/post/automate-google-pagespeed-insights-with-apps-script
-
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://ithoughthecamewithyou.com/post/automate-google-pagespeed-insights-with-apps-script
-
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.
-
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.
-
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://ithoughthecamewithyou.com/post/animation-of-a-year-of-global-cloud-cover
-
Get an email when a new OpenAI model is available via the API #code #software #appsscript #google #gmail #openai #ai Get an email when a new OpenAI model is available via the API
-
🎉 Automatically email birthday wishes to your contacts on their special day!
#GoogleSheets #AppsScript #BirthdayReminder
📌 Never forget a birthday—let this script do the work!
-
💰 Auto-fetch real-time exchange rates and convert prices in your spreadsheet without third-party plugins!
#GoogleSheets #AppsScript #CurrencyConverter
📌 Use this in formulas to dynamically convert currencies in your Google Sheet!
-
📌 Keep your Google Sheet clean by deleting rows older than X days! Perfect for logs, attendance records, or any auto-generated data.
#GoogleSheets #AppsScript #DataCleaning
📌 Run this weekly to keep only the last 30 days of data!
-
📊 Track trending topics automatically by pulling Google Trends data into Google Sheets every day!
#GoogleSheets #AppsScript #GoogleTrends #SEO
📌 Automate this to log trending searches every day and analyze patterns!
-
Auto-Remind You of Upcoming Bills & Due Dates 💸
📅 Never miss a payment again! This script checks your bill due dates in Google Sheets and emails you a reminder before they’re due.#GoogleSheets #AppsScript #Automation #BillTracking
Set this on a daily trigger and never forget a payment again!
-
💰 Auto-fetch real-time exchange rates and convert prices in your spreadsheet without third-party plugins!
#GoogleSheets #AppsScript #CurrencyConverter
📌 Use this in formulas to dynamically convert currencies in your Google Sheet!
-
🎉 Automatically email birthday wishes to your contacts on their special day!
#GoogleSheets #AppsScript #BirthdayReminder
📌 Never forget a birthday—let this script do the work!
-
📌 Keep your Google Sheet clean by deleting rows older than X days! Perfect for logs, attendance records, or any auto-generated data.
#GoogleSheets #AppsScript #DataCleaning
📌 Run this weekly to keep only the last 30 days of data!
-
📊 Track trending topics automatically by pulling Google Trends data into Google Sheets every day!
#GoogleSheets #AppsScript #GoogleTrends #SEO
📌 Automate this to log trending searches every day and analyze patterns!
-
Auto-Remind You of Upcoming Bills & Due Dates 💸
📅 Never miss a payment again! This script checks your bill due dates in Google Sheets and emails you a reminder before they’re due.#GoogleSheets #AppsScript #Automation #BillTracking
Set this on a daily trigger and never forget a payment again!
-
📈 Keep track of your daily habits with ease! This script creates a simple habit tracker that logs your progress.
#GoogleSheets #AppsScript #HabitTracker #LifeHacks
📌 Use this as a daily reminder and habit tracker for personal growth!
-
💪 Start your day with a positive affirmation! This script sends you an uplifting message every morning to boost your productivity and mood.
#GoogleSheets #AppsScript #Motivation #Affirmations
📌 Get your daily dose of positivity directly to your inbox!
-
📚 Want to reflect on your week? This script automatically generates a weekly review summarizing your work, habits, and accomplishments from your Google Sheets.
#GoogleSheets #AppsScript #WeeklyReview #Reflection
📌 Automatically email your weekly recap of achievements and tasks!
-
🛍️ Never forget an item again! This script automatically updates your grocery list by pulling items from a Google Sheet, and even sends a reminder to your phone or email.
#GoogleSheets #AppsScript #Automation
📌 Set this to send weekly or daily reminders with your updated grocery list!
-
📝 Want to keep track of your health and fitness? This script creates an easy way to log your exercise, water intake, and sleep every day.
#GoogleSheets #AppsScript #HealthTracking #FitnessGoals
📌 Log your health data daily and create a habit tracker with this!
-
📈 Keep track of your daily habits with ease! This script creates a simple habit tracker that logs your progress.
#GoogleSheets #AppsScript #HabitTracker #LifeHacks
📌 Use this as a daily reminder and habit tracker for personal growth!
-
📚 Want to reflect on your week? This script automatically generates a weekly review summarizing your work, habits, and accomplishments from your Google Sheets.
#GoogleSheets #AppsScript #WeeklyReview #Reflection
📌 Automatically email your weekly recap of achievements and tasks!
-
💪 Start your day with a positive affirmation! This script sends you an uplifting message every morning to boost your productivity and mood.
#GoogleSheets #AppsScript #Motivation #Affirmations
📌 Get your daily dose of positivity directly to your inbox!
-
📝 Want to keep track of your health and fitness? This script creates an easy way to log your exercise, water intake, and sleep every day.
#GoogleSheets #AppsScript #HealthTracking #FitnessGoals
📌 Log your health data daily and create a habit tracker with this!
-
🛍️ Never forget an item again! This script automatically updates your grocery list by pulling items from a Google Sheet, and even sends a reminder to your phone or email.
#GoogleSheets #AppsScript #Automation
📌 Set this to send weekly or daily reminders with your updated grocery list!
-
📝 This script sends your daily to-do list from Google Sheets to your email every morning!
#GoogleSheets #AppsScript #Productivity #Automation
📌 Set it to run every morning, and you’ll get a daily task list in your inbox!
-
💳 Tired of manually tracking expenses? This script automatically logs transactions from your Gmail (like bank alerts) into Google Sheets!
#GoogleSheets #AppsScript #Finance #ExpenseTracker
📌 Set a Gmail trigger, and your expenses get logged automatically!
-
💳 Tired of manually tracking expenses? This script automatically logs transactions from your Gmail (like bank alerts) into Google Sheets!
#GoogleSheets #AppsScript #Finance #ExpenseTracker
📌 Set a Gmail trigger, and your expenses get logged automatically!
-
⚠️ Too many duplicates in your dataset? Use this script to find and remove duplicate rows, keeping only one unique copy.
#GoogleSheets #AppsScript #RemoveDuplicates #DataCleaning
📌 Run this script, and all duplicates will be removed automatically!
-
🔄 Want to log every change made in your sheet? This script creates a timestamped log of changes, including the user, old value, and new value.
#GoogleSheets #AppsScript #ChangeLog #AuditTrail
📌 Set this as an onEdit trigger, and it will log every change!
-
📢 Want to schedule tweets directly from Google Sheets? This script posts tweets from a column at a scheduled time!
#GoogleSheets #AppsScript #TwitterAutomation #SocialMedia
📌 Set a time-based trigger, and your tweets will be posted automatically!
-
📢 Want to schedule tweets directly from Google Sheets? This script posts tweets from a column at a scheduled time!
#GoogleSheets #AppsScript #TwitterAutomation #SocialMedia
📌 Set a time-based trigger, and your tweets will be posted automatically!
-
⚠️ Too many duplicates in your dataset? Use this script to find and remove duplicate rows, keeping only one unique copy.
#GoogleSheets #AppsScript #RemoveDuplicates #DataCleaning
📌 Run this script, and all duplicates will be removed automatically!
-
⚠️ Too many duplicates in your dataset? Use this script to find and remove duplicate rows, keeping only one unique copy.
#GoogleSheets #AppsScript #RemoveDuplicates #DataCleaning
📌 Run this script, and all duplicates will be removed automatically!
-
🔄 Want to log every change made in your sheet? This script creates a timestamped log of changes, including the user, old value, and new value.
#GoogleSheets #AppsScript #ChangeLog #AuditTrail
📌 Set this as an onEdit trigger, and it will log every change!
-
🔄 Need to convert your Google Sheets data into JSON format for an API or integration? This Apps Script does it for you!
#GoogleSheets #AppsScript #JSON #DataTransformation
📌 This will output a JSON string of your Google Sheets data in the log.
-
🔄 Need to convert your Google Sheets data into JSON format for an API or integration? This Apps Script does it for you!
#GoogleSheets #AppsScript #JSON #DataTransformation
📌 This will output a JSON string of your Google Sheets data in the log.
-
📈 Need to send monthly invoices? Use this script to generate a PDF invoice from your Google Sheet data, and automatically email it to clients!
#GoogleSheets #AppsScript #Invoices #Automation
📌 Trigger this monthly to auto-generate invoices.