Aryan Irani
Aryan Irani
  • 122
  • 431 077
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: th-cam.com/video/U2ExjceK2O0/w-d-xo.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
มุมมอง: 100

วีดีโอ

Extract Hyperlinks from Text in Google Sheets using Google Apps Script | Aryan Irani
มุมมอง 124หลายเดือนก่อน
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
มุมมอง 3722 หลายเดือนก่อน
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
มุมมอง 1K3 หลายเดือนก่อน
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)
มุมมอง 1933 หลายเดือนก่อน
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
มุมมอง 2716 หลายเดือนก่อน
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: th-cam.com/video/aLqrP7WXGwI/w-d-xo.htmlsi=uNczNt7Kn1...
Mystery Revealed: Find out who has access to your Google Drive Files using Google Apps Script
มุมมอง 8026 หลายเดือนก่อน
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
มุมมอง 1.6K6 หลายเดือนก่อน
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
มุมมอง 1.3K7 หลายเดือนก่อน
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
มุมมอง 2.2K7 หลายเดือนก่อน
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: th-cam.com/video/gmWqhBolF-c/w-d-xo.htmlsi=l_oUYk_EMBGVhmy0 Check out the En...
Gemini Pro API + Google Apps Script : Build a Hotel Review Classifier | Aryan Irani
มุมมอง 2K8 หลายเดือนก่อน
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: th-cam.com/video/02MdyF5vbwM/w-d-xo.htmlsi=qJ3bgEUHO_IEwvwX Check out the Entire playlist: th-cam.com/play/PL_MCVB...
Master Hotel Reviews with Gemini Pro Model in Google AI Studio | Aryan Irani
มุมมอง 3108 หลายเดือนก่อน
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
มุมมอง 6638 หลายเดือนก่อน
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
มุมมอง 737ปีที่แล้ว
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
มุมมอง 4.2Kปีที่แล้ว
Integrate Bard into your Google Sheet using the PaLM API and Google Apps Script| Aryan Irani
PaLM API and Google Apps Script | Aryan Irani
มุมมอง 871ปีที่แล้ว
PaLM API and Google Apps Script | Aryan Irani
Everything You Need to Know About MakerSuite | Aryan Irani
มุมมอง 1.1Kปีที่แล้ว
Everything You Need to Know About MakerSuite | Aryan Irani
Apply for PaLM 2 Today | Aryan Irani
มุมมอง 593ปีที่แล้ว
Apply for PaLM 2 Today | Aryan Irani
What is PaLM 2 and MakerSuite? | Aryan Irani
มุมมอง 785ปีที่แล้ว
What is PaLM 2 and MakerSuite? | Aryan Irani
Summarise Your Documents in Seconds with @OpenAI API and Google Apps Script | Aryan Irani
มุมมอง 604ปีที่แล้ว
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
มุมมอง 7Kปีที่แล้ว
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
มุมมอง 604ปีที่แล้ว
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
มุมมอง 6Kปีที่แล้ว
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
มุมมอง 906ปีที่แล้ว
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
มุมมอง 744ปีที่แล้ว
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
มุมมอง 1.5Kปีที่แล้ว
Build an Automated Email Workflow using Google Apps Script - Part2 | Aryan Irani
Integrating Google Apps Script Web Apps into Your Website | Aryan Irani
มุมมอง 9Kปีที่แล้ว
Integrating Google Apps Script Web Apps into Your Website | Aryan Irani
Build an Automated Email Workflow using Google Apps Script - Part1 | Aryan Irani
มุมมอง 4.3Kปีที่แล้ว
Build an Automated Email Workflow using Google Apps Script - Part1 | Aryan Irani
Unlock Automated Email Magic with Google Sheets and Apps Script | Aryan Irani
มุมมอง 1Kปีที่แล้ว
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
มุมมอง 757ปีที่แล้ว
Machine Learning in Google Sheets - Create and train a Model in Simple ML | Aryan Irani

ความคิดเห็น

  • @ankushmaddan3262
    @ankushmaddan3262 วันที่ผ่านมา

    A bunch of data is collected how to take it out as xlsx format??😮 😮

  • @stevea.2131
    @stevea.2131 8 วันที่ผ่านมา

    Excellent video, thank you! Minor differences between the video and shared code are minimal that are easily understood.

  • @ThulasiRaghavendraRao
    @ThulasiRaghavendraRao 8 วันที่ผ่านมา

    Can i use Age builder and from Data dictionary excel file and get required database, table and field

  • @Furquan_
    @Furquan_ 13 วันที่ผ่านมา

    First dislike

  • @TilakConrad
    @TilakConrad 15 วันที่ผ่านมา

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

  • @TMCI-education
    @TMCI-education 27 วันที่ผ่านมา

    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 หลายเดือนก่อน

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

  • @lilianoyugi4927
    @lilianoyugi4927 หลายเดือนก่อน

    You are toopoo fast nkt

  • @rectape
    @rectape หลายเดือนก่อน

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

  • @chcrain1280
    @chcrain1280 หลายเดือนก่อน

    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 หลายเดือนก่อน

    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 2 หลายเดือนก่อน

    lovely let me play this game

  • @diegodelfino9409
    @diegodelfino9409 2 หลายเดือนก่อน

    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 2 หลายเดือนก่อน

    Sir i wanted task managment form

  • @thanhtin9623
    @thanhtin9623 2 หลายเดือนก่อน

    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 2 หลายเดือนก่อน

    Thanks a ton bro It helped me a lot

  • @jorgemateus3452
    @jorgemateus3452 2 หลายเดือนก่อน

    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 2 หลายเดือนก่อน

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

  • @MISKaligodam
    @MISKaligodam 2 หลายเดือนก่อน

    great sheet...👍🏼👍🏼 Nice Work

  • @Atmatan
    @Atmatan 2 หลายเดือนก่อน

    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 3 หลายเดือนก่อน

    How to build a form like cinemahall seat booking

  • @rahmanzabdul
    @rahmanzabdul 3 หลายเดือนก่อน

    please add audio. Stop playing music in tech videos

  • @umaalapati
    @umaalapati 3 หลายเดือนก่อน

    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 3 หลายเดือนก่อน

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

  • @PallaviChauhan91
    @PallaviChauhan91 4 หลายเดือนก่อน

    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 4 หลายเดือนก่อน

    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 4 หลายเดือนก่อน

    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 4 หลายเดือนก่อน

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

  • @Tangle-wood
    @Tangle-wood 4 หลายเดือนก่อน

    Hi Aryan how to connect to you

    • @AryanIrani123
      @AryanIrani123 4 หลายเดือนก่อน

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

  • @saikat_is_here
    @saikat_is_here 4 หลายเดือนก่อน

    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 4 หลายเดือนก่อน

    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 5 หลายเดือนก่อน

    Can we create follow ups?

  • @jyow32
    @jyow32 5 หลายเดือนก่อน

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

  • @shivaramabharadwaja2234
    @shivaramabharadwaja2234 5 หลายเดือนก่อน

    Thanks dude. Great one

  • @AtomicPixels
    @AtomicPixels 5 หลายเดือนก่อน

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

  • @lamechemohh9113
    @lamechemohh9113 5 หลายเดือนก่อน

    How i find the old prompt used with aistudio?

  • @israelterorisprikopat
    @israelterorisprikopat 5 หลายเดือนก่อน

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

  • @nick_the_padbreaker
    @nick_the_padbreaker 5 หลายเดือนก่อน

    This is way too time-consuming.

  • @gioprava
    @gioprava 5 หลายเดือนก่อน

    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 5 หลายเดือนก่อน

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

  • @imransik786
    @imransik786 6 หลายเดือนก่อน

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

  • @imransik786
    @imransik786 6 หลายเดือนก่อน

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

  • @jakobbourne6381
    @jakobbourne6381 6 หลายเดือนก่อน

    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 6 หลายเดือนก่อน

  • @AavulaKumar-u7v
    @AavulaKumar-u7v 6 หลายเดือนก่อน

    Thank you so much its working :)

    • @AryanIrani123
      @AryanIrani123 6 หลายเดือนก่อน

      You're welcome!

  • @AmitJain-r6s
    @AmitJain-r6s 6 หลายเดือนก่อน

    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 6 หลายเดือนก่อน

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

  • @Hoaithu100
    @Hoaithu100 6 หลายเดือนก่อน

    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 7 หลายเดือนก่อน

    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 7 หลายเดือนก่อน

    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

  • @HarshitSomal
    @HarshitSomal 7 หลายเดือนก่อน

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