#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
-
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
-
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!
-
I feel like I should expand a bit on this, but I'm not near my blogging machine right now. But it goes like this:
"Hey, we should let people automate Google Docs."
"Good idea. What kind of abstraction should we use? Should we use something like emacs, which takes advantage of the fact you're already in a document editor and lets you use the tool suite of the document editor itself to manipulate the documents? So concepts like 'you insert at cursor' and 'you have powerful search abstractions' and 'you can use templates to inject complicated content?'"
"No. Let's pretend the document is something like HTML and use a DOM abstraction, so you have to treat the document like it's an array of things, making inserting several sequential things in the middle just the worst. Oh, and let's make inserting anything complex about as fun as writing Java GUIs in AWT. You know how at least the DOM lets you directly inject HTML and interpret it into new nodes? Let's definitely not do that."
"Sounds good. Should we provide powerful search abstractions inspired by CSS queries?"
"Hah, of course not! When I said 'DOM' I meant 'the first generations of the DOM.' Let's have search by element type and string contents and basically nothing else!"
"Oh, right! We really want to recreate the conditions that led to people making two or three incompatible 'the way the DOM should have worked' abstraction libraries! I can't wait for someone to try to write 'JQuery, but for our awful Apps Script API!'"
"Now you're catching on! Except they won't because it'll never be that popular!"
"Awesome!"
-
I should write a full blog post on this later, but in short: I wrote some Apps Script to automate a bit of a Google Doc, and wow is that a bad API for the task.
We need to stop patterning things after the DOM because the DOM is bad, actually.
-
today I delivered on a product that has taken me seven months. Written in a language that I have never formally been trained on. It's an mvp, but it's the first time it has ever worked as intended. I am simultaneously thrilled and dead.
#WomenWhoCode #Java #AppsScript #DataScience #Analytics #Product
-
#Python in #GoogleSheets via #Rust and #Wasm 🤯
I have 15 minutes to talk about this at #Google Cloud Next in April! https://cloud.withgoogle.com/next?session=IHLT300
-
And why not #python interpreted in #rust compiled to #wasm for #AppsScript for #GoogleWorkspace
-
Rust in Apps Script 🤪
-
Monitor page index status with Google Sheets, Apps Script and the Google Search Console API #code #searchconsole #appsscript #google #sheets #drive #seo How to use Apps Script in Google Sheets to automatically monitor index status in Google Search Console and get an email alert if anything changes.
-
Finished first pass of my first #appsscript to pull data from thebluealliance.com to #GoogleSheets for #frcRobotics
https://github.com/AusTINCANsProgrammingTeam/canalytics/tree/scouting-charts/appscripts
Sharp edges: caching service is goofy, it takes so long to execute a function from a sheet cell, and really don't like using =query() in sheets.
Now that the initial work is done, the hope is to get the team involved in updating the script for kickoff, and then more engaged on scouting during competition.
-
Working on an #appsscript to make rest calls and store data in a google sheet for a #frcrobotics scouting project. Painful.
1. Examples in official docs were not practical.
How can I read this entire spreadsheet and log each value? Said no one. Ever.
2. I tried to put JSON into the Cache Service, instead of a string. ( My bad ) And it silently failed.
But it takes a special flag to be able to handle HTTP error codes without an exception.
consistent #UX is important