#appsscript — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #appsscript, aggregated by home.social.
-
Получить цены акций, фондов и ОФЗ в Google Sheets
Привет, Хабр! Изучая информацию по работе с API в таблицах Google/Excel, понял лишь то, что я ничего не понимаю, разбираться в xpath, в парсинге XML внутри формулы это всё, как-то очень тяжело и громостко. У меня была простая задача, разработать что бы то ни было для получения текущей цены по конкретному активу с Мосбиржи. И как мне кажется, у меня это получилось в дотаточной степени чтобы можно было получить информацию и далее, как-то её агригировать, как вам удобно. Также сразу поясню, что функция GOOGLEFINANCE больше не работает, по этому остается искать другие пути решения.
https://habr.com/ru/articles/964722/
#api #GoogleТаблицы #excel #xpath #json #мосбиржа #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
-
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
-
💰 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!
-
💰 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 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 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 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!
-
💳 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!
-
⚠️ 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 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.
-
🔄 Want to create a live dashboard that pulls data from external sources like Google Analytics or CRM?Use Apps Script to fetch and display real-time data automatically in your Google Sheets dashboard
#GoogleSheets #AppsScript #LiveData
📌 Set a time-based trigger to keep your dashboard updated!
-
🔄 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.
-
🔄 Want to create a live dashboard that pulls data from external sources like Google Analytics or CRM?Use Apps Script to fetch and display real-time data automatically in your Google Sheets dashboard
#GoogleSheets #AppsScript #LiveData
📌 Set a time-based trigger to keep your dashboard updated!
-
📥 Need to aggregate data from multiple Google Sheets into one? Use Apps Script to pull data from different sheets and compile it into a central master sheet.
-
📥 Need to aggregate data from multiple Google Sheets into one? Use Apps Script to pull data from different sheets and compile it into a central master sheet.
-
Как использовать Google Sheets в качестве базы данных
Привет, я Настя — младший разработчик в M2 . М2 - это экосистема цифровых сервисов, которые помогают пользователям проводить сделки с недвижимостью удобно, быстро и безопасно. Мы с командой разрабатываем CMS, которая позволяет управлять контентом на сайте m2.ru Расскажу о том, как мы используем Apps Script для парсинга данных из Google Sheets и зачем это нам. Если вам интересна только пошаговая инструкция с примерами кода, ее можно посмотреть здесь .
-
It would be great if #AppsScript would support more of the #WinterCG minimum API. Almost nothing is supported except for WebAssembly, which is a little more challenging to use without `TextEncoder` and `TextDecoder`.
https://justin.poehnelt.com/posts/apps-script-runtime-limitations-wintercg/