Aryan Irani
Aryan Irani
  • 122
  • 425 615
Automate Subscription Renewal using Google Apps Script | Aryan Irani
Managing subscription renewals can be a headache for any business, keeping track of memberships and reminding clients about renewal, often resulting in lost customers.
To address this, I built an automation workflow using Google Sheets and Google Apps Script, which simplified the process of reminding the clients about their subscription renewal.
Work with the Sheet: docs.google.com/spreadsheets/d/1ftCIgfskrgLgPY0q_OW1DtZmWi6P6XuNcAdoJ8YZvpc/copy
Work with the Code: github.com/aryanirani123/Google-Apps-Script/blob/master/Renewal.js
More about Class Date: developers.google.com/apps-script/reference/document/date
Use Triggers to Execute your Apps Script code: czcams.com/video/U2ExjceK2O0/video.htmlsi=Rjx6mI4oe5VY2pz1
Check out the Blog Post: medium.com/@aryanirani123/automate-subscription-renewal-using-google-apps-script-99a6652f825b
| Socials |
Twitter : x.com/aryanirani123
LinkedIn : www.linkedin.com/in/aryanirani123/
Medium : medium.com/@aryanirani123
Website : www.aryanirani123.com/
Instagram: aryanirani123
Hi. I am Aryan Irani. I am a Google Developer Expert, Champion Innovator for Google Workspace, a Technical Writer, Developer.
#googlesheets #googleappscript #googleworkspace
zhlédnutí: 85

Video

Extract Hyperlinks from Text in Google Sheets using Google Apps Script | Aryan Irani
zhlédnutí 102Před 14 dny
Recently, I was making a collection of all Medium articles and basically copied the links of the articles and stored them in a Google Sheet. I wanted to extract the links from the cell text and paste them into the adjacent column. In this video we will be looking at extracting HyperLinks from Cell Text in Google Sheets using the RichTextValue Class and Google Apps Script. Work with the sheet: d...
Boost Your Productivity with NotebookLM from Google | Aryan Irani
zhlédnutí 304Před měsícem
In this video we will be looking at NotebookLM by Google. NotebookLLM by Google is a free, experimental research assistant that can help upload your class notes, textbooks, and research papers, and NotebookLLM will summarise the key points, identify important topics, and even answer your questions directly from the content. *It's NotebookLM and not LLM* :) Check out NotebookLM by Google: notebo...
Vertex AI Agent Builder for Developers | Aryan Irani
zhlédnutí 934Před 2 měsíci
Society Bye-laws are complex. What if you could have a chatbot that can answer any queries about Bye-Laws? In my latest blog post, I show you how you can build a chatbot that talks to your data using Vertex AI's Agent Builder. In this video, we will be building a ChatApp with Vertex AI Agent Builder that allows us to talk to our data. CodeLab: codelabs.developers.google.com/codelabs/vertex-ai-c...
Send Email From Google Sheets (Easiest Way 2024)
zhlédnutí 175Před 3 měsíci
Learn how to send email from Google Sheets in just a few simple steps. Sending emails from Google Sheets has never been easier. Lido Resources: www.lido.app/resources Sign up for Lido using this link: www.lido.app/link/aryan Follow me on : Twitter : cutt.ly/Rv4Ydun LinkedIn: cutt.ly/Fv4YayL Medium: aryanirani123.medium.com/ Hi. I am Aryan Irani. I am a Google Developer Expert for Google Workspa...
Create Engaging Marketing Content with Google AI Studio | Aryan Irani
zhlédnutí 267Před 5 měsíci
In this video we are going to be taking a look at the Gemini Pro Vision inside of Google AI Studio. We are going to be building a Marketing description writer inisde of Google AI Studio With the use of images in prompts, we are going to generate marketing description of products using the Gemini Pro Vision Model. AI based interior decorator: czcams.com/video/aLqrP7WXGwI/video.htmlsi=uNczNt7Kn1S...
Mystery Revealed: Find out who has access to your Google Drive Files using Google Apps Script
zhlédnutí 776Před 6 měsíci
In this video we will be taking a look at how to get a list of people/emails who have access to your Google Drive Files using Google Apps Script. These files could be anything from a Google Sheet, Google Doc, Google Slides and more. All you need is the id of the file and you can have the list of people who have access to your Google Drive Files. Google Apps Script Code Link: github.com/aryanira...
What's new with Google AI Studio? Gemini 1.5 Pro,Videos in prompts, Fine tuning models | Aryan Irani
zhlédnutí 1,6KPřed 6 měsíci
In the past few weeks, Google has made a lot of advancements in the space of generative AI by making various updates to Google AI studio. In this video we will be talking about updates like the new Gemini 1.5 Pro model, Adding videos to prompts and fine tuning models. This video covers everything you need to know about all the new updates for Google AI Studio and all the amazing solutions you c...
Gemini for Google Workspace | Aryan Irani
zhlédnutí 1,3KPřed 6 měsíci
In this video we will be looking at Gemini for Google Workspace. Google has now integrated the power of Gemini inside of Google Workspace, allowing us to use products like Google Docs, Google Sheet and much more with AI. We will be covering all the Gemini Integrations made inside of Google Docs, Google Sheets, Google Drive and Gmail. Check out the latest updates for Gemini: workspace.google.com...
Getting started with Structured Prompts in Google AI Studio | Aryan Irani
zhlédnutí 2,2KPřed 6 měsíci
In this video we will be taking a look at Structured Prompts inside of Google AI Studio. We will be taking a very simple of example of a Grammar Corrector and get a better understanding of Structured Prompts work. Google AI Studio Documentation: ai.google.dev/tutorials/ai-studio_quickstart Check out the previous video: czcams.com/video/gmWqhBolF-c/video.htmlsi=l_oUYk_EMBGVhmy0 Check out the Ent...
Gemini Pro API + Google Apps Script : Build a Hotel Review Classifier | Aryan Irani
zhlédnutí 2KPřed 7 měsíci
In this video we will be taking a look at how we build a Hotel Review Classifier using the Gemini Pro API and Google Apps Script. This video talks about Google Workspace automation, where we experiment upon hotel reviews received through a Google Form. Check out the previous video: czcams.com/video/02MdyF5vbwM/video.htmlsi=qJ3bgEUHO_IEwvwX Check out the Entire playlist: czcams.com/play/PL_MCVBM...
Master Hotel Reviews with Gemini Pro Model in Google AI Studio | Aryan Irani
zhlédnutí 307Před 8 měsíci
In this video, we're diving into the world of hotel reviews and tackling them head-on with the coolest AI tech around. We'll be building our own review classifier using the Gemini Pro model inside Google AI Studio. It's like having a robot whisperer for guest feedback! Check out Google Bard: blog.google/technology/ai/bard-google-ai-search-updates/ Check out Google AI Studio: makersuite.google.c...
Google AI Studio + Gemini Pro Vision: Build a Text-Based Living Room Decor Assistant | Aryan Irani
zhlédnutí 649Před 8 měsíci
Struggling to visualize your dream space? Ditch the decor daze and unlock the secrets of a stunning living room with your own personal interior design AI: Gemini Pro Vision! ️ FreeForm Prompts Feed Gemini Pro a picture of your existing space or just a Pinterest dream, and watch it spin out text-based design suggestions - colours, furniture, layouts, you name it! Check out Google Bard: blog.goog...
Create Google Doc Summaries using the PaLM API and Google Apps Script | Aryan Irani
zhlédnutí 730Před rokem
Create Google Doc Summaries using the PaLM API and Google Apps Script | Aryan Irani
Integrate Bard into your Google Sheet using the PaLM API and Google Apps Script| Aryan Irani
zhlédnutí 4,2KPřed rokem
Integrate Bard into your Google Sheet using the PaLM API and Google Apps Script| Aryan Irani
PaLM API and Google Apps Script | Aryan Irani
zhlédnutí 869Před rokem
PaLM API and Google Apps Script | Aryan Irani
Everything You Need to Know About MakerSuite | Aryan Irani
zhlédnutí 1,1KPřed rokem
Everything You Need to Know About MakerSuite | Aryan Irani
Apply for PaLM 2 Today | Aryan Irani
zhlédnutí 591Před rokem
Apply for PaLM 2 Today | Aryan Irani
What is PaLM 2 and MakerSuite? | Aryan Irani
zhlédnutí 780Před rokem
What is PaLM 2 and MakerSuite? | Aryan Irani
Summarise Your Documents in Seconds with @OpenAI API and Google Apps Script | Aryan Irani
zhlédnutí 592Před rokem
Summarise Your Documents in Seconds with @OpenAI API and Google Apps Script | Aryan Irani
Building a Web App from Scratch with Google Apps Script: Distance and Time Calculator | Aryan Irani
zhlédnutí 7KPřed rokem
Building a Web App from Scratch with Google Apps Script: Distance and Time Calculator | Aryan Irani
Automating Blog Summarisation with Google Apps Script and Open AI API | Aryan Irani #openai
zhlédnutí 594Před rokem
Automating Blog Summarisation with Google Apps Script and Open AI API | Aryan Irani #openai
Use Google Apps Script to Calculate Distance and Time in Google Sheets | Aryan Irani
zhlédnutí 5KPřed rokem
Use Google Apps Script to Calculate Distance and Time in Google Sheets | Aryan Irani
Maximising Productivity with Google Apps Script and Chat GPT Integration | Aryan Irani
zhlédnutí 886Před rokem
Maximising Productivity with Google Apps Script and Chat GPT Integration | Aryan Irani
Maximising Google Sheets: Generate Google Map Links to Boost Your Productivity | Aryan Irani
zhlédnutí 720Před rokem
Maximising Google Sheets: Generate Google Map Links to Boost Your Productivity | Aryan Irani
Build an Automated Email Workflow using Google Apps Script - Part2 | Aryan Irani
zhlédnutí 1,5KPřed rokem
Build an Automated Email Workflow using Google Apps Script - Part2 | Aryan Irani
Integrating Google Apps Script Web Apps into Your Website | Aryan Irani
zhlédnutí 9KPřed rokem
Integrating Google Apps Script Web Apps into Your Website | Aryan Irani
Build an Automated Email Workflow using Google Apps Script - Part1 | Aryan Irani
zhlédnutí 4,3KPřed rokem
Build an Automated Email Workflow using Google Apps Script - Part1 | Aryan Irani
Unlock Automated Email Magic with Google Sheets and Apps Script | Aryan Irani
zhlédnutí 1KPřed rokem
Unlock Automated Email Magic with Google Sheets and Apps Script | Aryan Irani
Machine Learning in Google Sheets - Create and train a Model in Simple ML | Aryan Irani
zhlédnutí 745Před rokem
Machine Learning in Google Sheets - Create and train a Model in Simple ML | Aryan Irani

Komentáře

  • @Furquan_
    @Furquan_ Před 2 hodinami

    First dislike

  • @TilakConrad
    @TilakConrad Před 2 dny

    another great tutorial - done superbly - congratulations and thank you very much - all the very best with your channel

  • @TMCI-education
    @TMCI-education Před 14 dny

    I'm running into the issue in which users keep getting email notifications that a file is being shared. This happens each time the code is ran. Is there a way that users get notified once and that is it?

  • @etechsoftware964
    @etechsoftware964 Před 20 dny

    Nice Tutorial. But how can one get the pdfs generated downloadable link on every individual student on a new column

  • @lilianoyugi4927
    @lilianoyugi4927 Před 27 dny

    You are toopoo fast nkt

  • @rectape
    @rectape Před měsícem

    Hi, I get : TypeError: Cannot read properties of null (reading 'getDataRange')

  • @chcrain1280
    @chcrain1280 Před měsícem

    I've been using AI to develop google scripts and I'm trying to change the url of the google script to be a public domain. I didn't even know about sites.google though. This is huge, thanks for the vid.

  • @jameskelly8238
    @jameskelly8238 Před měsícem

    Very well presented with clear explanations at each stage. I have looked at a few eother videos describinng how to read/write to a Google sheet, but this is by far the best one I encountered.

  • @zubairmansoori2200
    @zubairmansoori2200 Před měsícem

    lovely let me play this game

  • @diegodelfino9409
    @diegodelfino9409 Před měsícem

    Thank you! I have a question: If i run the AppScript and then one of the events in the Calendar get cancelled, how I can automatically remove it from the Google Sheet as well?

  • @satishpatilkulkarni9434
    @satishpatilkulkarni9434 Před měsícem

    Sir i wanted task managment form

  • @thanhtin9623
    @thanhtin9623 Před měsícem

    Hello, please your support about my question. My GG form has 3 sessions And GG sheet has 3 sheets with answers I would like to link every session once submitted will return the confirmation message that shows each row of the sheet that corresponding to every session. Like the session 1 linked to sheet 1 Session 2 link to sheet 2 Session 3 link to sheet 3

  • @rs-tarxvfz
    @rs-tarxvfz Před měsícem

    Thanks a ton bro It helped me a lot

  • @jorgemateus3452
    @jorgemateus3452 Před 2 měsíci

    Great content thanks! one suggestion tho, the animation to subscribe at around 3.26 is waaaayy to loud compared to you voice, it scared me lol, try to better adjust volume on other videos!

    • @AryanIrani123
      @AryanIrani123 Před měsícem

      Thanks for the feedback ! I apologise if it scared you 😅

  • @MISKaligodam
    @MISKaligodam Před 2 měsíci

    great sheet...👍🏼👍🏼 Nice Work

  • @Atmatan
    @Atmatan Před 2 měsíci

    Do you know of any scripts that will turn a file system into a series of structured prompts for fine tuning? Google seriously made this as inconvenient as humanly possible.

  • @mdx_yt
    @mdx_yt Před 2 měsíci

    How to build a form like cinemahall seat booking

  • @rahmanzabdul
    @rahmanzabdul Před 2 měsíci

    please add audio. Stop playing music in tech videos

  • @umaalapati
    @umaalapati Před 2 měsíci

    Hi Aryan- Thanks, for putting these instructions togather, quiet useful. Is it possible, to share the pdf doc link, please?. I can't find in the links you shared.

  • @turn-me-later
    @turn-me-later Před 3 měsíci

    What about find all email whos has access to my google drive?

  • @PallaviChauhan91
    @PallaviChauhan91 Před 3 měsíci

    This is huge! I was exactly looking for something like this. What a tip! I was looking to analyse some data which had both image and text inputs. Instead of going for a paid plan in chatgpt, I was doing this on gemini but pasting everything one by one was taking time. This way I just pasted it as one good example and now I can keep editing the image and text input for new analysis. Can't thank yo uenough for making this video. Please keep creating more stuff on gemini. There is shortage of good content on that.

  • @BettySwollocks13
    @BettySwollocks13 Před 3 měsíci

    Hi, please could anyone help, I have 10 identical vehicles and I have created a spreadsheet for each in sheets, each vehicle having a different serial number. I have then created an app in app sheets but on some of the options I have created drop down menus e.g. different drivers, different, destinations, different jobs etc. Now rather than repeating the data input for each vehicle, can I just duplicate each app and then just change the name of the app to the serial number I want- It’s the drop-down menu inputs that I do not want to manually fill in, it will take me an age…..any help greatly received. Thanks.

  • @googleuser7348
    @googleuser7348 Před 4 měsíci

    There is no option for embed link in hostinger website builder only embed code can use. How to use apps scripts as embed code?

  • @bobmay4362
    @bobmay4362 Před 4 měsíci

    Thanks for this. Can you suggest how to get Gmail to prompt to add labels when sending an email?

  • @Tangle-wood
    @Tangle-wood Před 4 měsíci

    Hi Aryan how to connect to you

    • @AryanIrani123
      @AryanIrani123 Před 4 měsíci

      You can contact me on my email: aryanirani123@gmail.com

  • @saikat_is_here
    @saikat_is_here Před 4 měsíci

    how to find real time distance (while driving) to multiple gps coordinates at the same time on google sheet? apps script tutorial please.

  • @WasanAssad
    @WasanAssad Před 4 měsíci

    thank you for this video, but when I applied I have a problem only first choice will take the message when I try to next choice it still without changing

  • @aayasir217
    @aayasir217 Před 4 měsíci

    Can we create follow ups?

  • @jyow32
    @jyow32 Před 5 měsíci

    When my nested SUBSTITUTE is executed, some of the &entry.#######s in the Form Link url get altered. Help.

  • @shivaramabharadwaja2234
    @shivaramabharadwaja2234 Před 5 měsíci

    Thanks dude. Great one

  • @AtomicPixels
    @AtomicPixels Před 5 měsíci

    What is even taught here. Beyond what’s literally just in Google’s UI already

  • @lamechemohh9113
    @lamechemohh9113 Před 5 měsíci

    How i find the old prompt used with aistudio?

  • @israelterorisprikopat
    @israelterorisprikopat Před 5 měsíci

    To compare 2 location. It use google map free. Is it okay? Or there are limitation request?

  • @captain_trump
    @captain_trump Před 5 měsíci

    This is way too time-consuming.

  • @gioprava
    @gioprava Před 5 měsíci

    Hello there, and thanks a lot for your video. @AryanIrani123 I would like to limit the responses not on the number of answers but based on the value of a cell in the google sheet linked to the code, is it possible? Basically I have an event where different groups of people can register to participate, and I would like to limit the registration to a number that is less or equal of 400. So my idea wold be to put a SUM in a cell on the google sheet to check the number of participants, and then block the form if the number is higher than 400...

  • @ZahratAlafrah
    @ZahratAlafrah Před 5 měsíci

    Thank you for this explanation .... We have a problem... Exception: Service invoked too many times for one day: route

  • @imransik786
    @imransik786 Před 5 měsíci

    please create video on how to integrate Gemini in google sheets.

  • @imransik786
    @imransik786 Před 5 měsíci

    Bro how to connect Gemini api key in google sheets Aaps Script

  • @jakobbourne6381
    @jakobbourne6381 Před 5 měsíci

    By harnessing the power of *Phlanx's caption generator* , businesses can elevate their social media marketing efforts to new heights, driving meaningful engagement, fostering brand loyalty, and ultimately, driving revenue growth. Its AI-driven capabilities provide a competitive advantage that sets businesses apart in today's digital age.

  • @nolowcode
    @nolowcode Před 6 měsíci

  • @user-xt3em7uy9g
    @user-xt3em7uy9g Před 6 měsíci

    Thank you so much its working :)

  • @user-ig8zb2jh3i
    @user-ig8zb2jh3i Před 6 měsíci

    Hi Aryan, This is realy a amazing code thanks for your sharing this code. Only one issue I am facing in this code that code runs in all the sheets Column A. Its pring date and time in each and every sheet of column A. Please suggest how to fix this.

  • @MohammadSGholizadeh
    @MohammadSGholizadeh Před 6 měsíci

    I signed up for the waitlist but I didn't hear back.

  • @Hoaithu100
    @Hoaithu100 Před 6 měsíci

    For fine tuning gemini pro. Have you ever called it api in code. Because when I call its api they said it's not possible in v1meta3 api

  • @eugeniomeza2886
    @eugeniomeza2886 Před 6 měsíci

    I got this error: "The parameters (number[]) don't match the method signature for DocumentApp.Body.appendTable." and it was a column that contains dates. As I removed that column from the range, it runs perfect.

  • @andrisreinholds8271
    @andrisreinholds8271 Před 6 měsíci

    Hi! Thanks the video. Tried to replicate the same only, but Im getting error "TypeError: Cannot read properties of undefined (reading 'namedValues')". Not sure what went wrong. Would greatly appreciate help on this one

  • @user-vt4dk9rm3c
    @user-vt4dk9rm3c Před 7 měsíci

    I am seeing this issue while running the code- service documents failed while accessing document with id

  • @eugeniomeza2886
    @eugeniomeza2886 Před 7 měsíci

    Excellent turorial!!! Congratulations, and keep up the good work.

  • @jonathandorozowsky4005
    @jonathandorozowsky4005 Před 7 měsíci

    Awesome! Thanks! How did you manage to figure out the maps query url?

  • @louli_me
    @louli_me Před 7 měsíci

    hello.. great work! But I got this error "ReferenceError: Crs is not defined". Can you help me, please? What does that mean?