Ashton Fei

Ashton Fei

🧑🏻‍💻 automate the boring.

I am a freelancer who is focusing on daily workflow automation, this channel is a recording of my learning progress and projects I want to share with the world.

- Process Automation with Google Apps Script
- Reporting with Google Sheet, Google Data Studio, Power BI
- Data scrapping with Apps Script
- API integration with Apps Script for Google Workspace Apps (Google Sheet/Doc/Slide/Form)
- Lightweight web apps with Google Sheet as database/free hosting/no server required

💮 About me 🔗 onescript.work/about
💮 Upwork with me 🔗www.upwork.com/workwith/ashtofei/

Пікірлер

  • @totoystone6562
    @totoystone65625 күн бұрын

    thank you so much sir

  • @tikakandel3
    @tikakandel311 күн бұрын

    Hello @ashtonfei this is great. I approve the first one, the link automatically gets changed and goes to the page not found. However, it sends a notification to the second approver but for the "this.url" variable here, the link gets changed or becomes a random link "template.approvalProgressUrl = `${this.url}?responseId=${responseId}`"; I copy the code from github. Has anyone had same issue?

  • @lindsey4416
    @lindsey441612 күн бұрын

    How can the cat breathe with such a deformed face? Poor thing.

  • @ashtonfei
    @ashtonfei12 күн бұрын

    He has some issues with eating so I am helping to feed him.🥹

  • @carolasieben9147
    @carolasieben914712 күн бұрын

    Very sweet

  • @patipahnlaejunkham1154
    @patipahnlaejunkham115415 күн бұрын

    My side is not working. Can you help me

  • @englishzeal.website
    @englishzeal.website15 күн бұрын

    I can't thank you enough Mr. Ashton .. Please, keep sharing like these projects with us :)

  • @MantenimentTrespins
    @MantenimentTrespins16 күн бұрын

    file Not Found Error 404

  • @MantenimentTrespins
    @MantenimentTrespins16 күн бұрын

    file Not Found Error 404

  • @marialuisa0712
    @marialuisa071217 күн бұрын

    Dai, una carezza è bella... 😅

  • @MrLococaco
    @MrLococaco17 күн бұрын

    how to link the new form with the sheet you show? When creating a new form, it creates another sheet

  • @ashtonfei
    @ashtonfei17 күн бұрын

    In the new form, unlink it from the new spreadsheet and relink it to the one we need, manually added the columns start with underscore.

  • @MrLococaco
    @MrLococaco17 күн бұрын

    ​@@ashtonfeiExcelente, tenía que colocar el mismo nombre de la hoja principal 🎉🎉🎉🎉🎉 muchas gracias

  • @MrLococaco
    @MrLococaco17 күн бұрын

    Is there a way for the email to be sent to more people and once they all sign, the document is generated?

  • @ashtonfei
    @ashtonfei17 күн бұрын

    It’s possible, but more customization will be needed. And we need the form to handle multiple people in the same response. The workflow could be different.

  • @MrLococaco
    @MrLococaco16 күн бұрын

    @@ashtonfei Ojalá puedas realizarlo algún día. Gracias 🫂

  • @MrLococaco
    @MrLococaco17 күн бұрын

    Excelente

  • @nurasian7355
    @nurasian735517 күн бұрын

    ❤❤❤

  • @SahraSinan-tv7oh
    @SahraSinan-tv7oh19 күн бұрын

    Cuteness overload 🥰🥰🥰🥰🥰🥰

  • @visorkatossa
    @visorkatossa21 күн бұрын

    It works

  • @PeeJoyHuaikrai
    @PeeJoyHuaikrai21 күн бұрын

    I have added Drive API. Why does this error still happen? TypeError: Drive.Files.insert is not a function

  • @ashtonfei
    @ashtonfei21 күн бұрын

    Check the api version, if it’s v3 then change it to v2. I may use the old version when I created the project.

  • @PeeJoyHuaikrai
    @PeeJoyHuaikrai14 күн бұрын

    @@ashtonfei Thank you so much

  • @allenwaters3638
    @allenwaters363822 күн бұрын

    Cute cat

  • @lynnbowlin4138
    @lynnbowlin413822 күн бұрын

    im the first comment ever on this vid

  • @allenwaters3638
    @allenwaters363822 күн бұрын

    Nice

  • @santinolomes8490
    @santinolomes849023 күн бұрын

    Is a cute little grumpy cat I love it

  • @LofiZ-gr7ce
    @LofiZ-gr7ce27 күн бұрын

    Hello, thank you for your useful video. Currently I am trying your worksheet but it gives an error when executing: Forbidden at updateSubtitles_ (1.api:176:18)

  • @ashtonfei
    @ashtonfei21 күн бұрын

    Hmm, I just run a test with my account, and I don't have this issue. Maybe you don't have the proper access to the video you want to update (Forbidden). Are you the owner of the Channel? stackoverflow.com/questions/51268669/getting-a-403-forbidden-error-for-youtube-data-api

  • @LofiZ-gr7ce
    @LofiZ-gr7ce21 күн бұрын

    @@ashtonfei I tried again, it only worked on personal channels attached to gmail, brand channels were not effective.

  • @LofiZ-gr7ce
    @LofiZ-gr7ce21 күн бұрын

    @@ashtonfei can you fix it

  • @ashtonfei
    @ashtonfei21 күн бұрын

    @LofiZ-gr7ce Unfortunately, I only have the personal account to test.

  • @talandria_digital_learning
    @talandria_digital_learningАй бұрын

    Hello , thanks for your tips, i have an error to start initialize ...

  • @blaxc
    @blaxcАй бұрын

    Form submission doesn't trigger the function. Is it needed to create a trigger function for form submission?

  • @ashtonfei
    @ashtonfeiАй бұрын

    Yes, a trigger has to be created to run the script for updating the confirmation message so the next ID can be shown for the next response.

  • @joyboythesungod123
    @joyboythesungod123Ай бұрын

    Ohhh 🫢 first cat is ugly

  • @samin-ku7wr
    @samin-ku7wrАй бұрын

    😘😘😍😍😍😍😍

  • @samin-ku7wr
    @samin-ku7wrАй бұрын

    ❤❤❤❤❤❤

  • @Dcamposmunoz
    @DcamposmunozАй бұрын

    Amazing, you are the best.

  • @ilitted7586
    @ilitted7586Ай бұрын

    i very like this code can i have this script please!!!

  • @ashtonfei
    @ashtonfeiАй бұрын

    You should be able to find the link in the description.

  • @varyaivanova6392
    @varyaivanova6392Ай бұрын

    That is surely one distinguished individual in their natural habitat!❤

  • @user-zi7mk5gt6l
    @user-zi7mk5gt6lАй бұрын

    My cat does the same 😄

  • @arum.69k
    @arum.69kАй бұрын

    Bro very good video, I have a question. I have a GYM. So I have my clients on a spreadsheet. Name of the customer, the start date and the end date of their subscription. Up to that point everything was fine. Now I would like to take that data to a Google Task. I don't know if you could help me give me an idea of ​​how I could create that Scrip. thank you so much

  • @ashtonfei
    @ashtonfeiАй бұрын

    Will these tasks be created all in your account? Or you will need to create them for your clients and the coaches?

  • @arum.69k
    @arum.69kАй бұрын

    @@ashtonfei That's right for me. The idea is to be able to create a simple task with a name, start date and end date. And then upload that data as a task in Google task, I have been using copilot. But I reached a point where the task is created but the date is not recorded. My programming knowledge is low so it is difficult for me to identify the fault. Since I created a code with the help of copilot.

  • @ashtonfei
    @ashtonfeiАй бұрын

    @@arum.69k Try this function to create a new task into your account, make sure the Google Tasks API is enabled in the advanced services. const createTask = (title = 'This is a test task', dueDate = '2024-06-04', listName = 'My Tasks') => { // find the task list by name const getTaskListByName_ = (name) => { const items = Tasks.Tasklists.list().items return name ? items.find(v => v.title === name) : items[0]; } const tasklist = getTaskListByName_(listName); // create the task instance const taskInstance = Tasks.newTask(); taskInstance.title = title; taskInstance.due = new Date(dueDate).toISOString(); // format the due date; // more properties developers.google.com/tasks/reference/rest/v1/tasks#resource:-task // create the task in the found task list; const task = Tasks.Tasks.insert(taskInstance, tasklist.id); return task; }

  • @arum.69k
    @arum.69kАй бұрын

    Bro very good video, I have a question. I have a GYM. So I have my clients on a spreadsheet. Name of the customer, the start date and the end date of their subscription. Up to that point everything was fine. Now I would like to take that data to a Google Task. I don't know if you could help me give me an idea of ​​how I could create that Scrip. thank you so much

  • @technicalknowledge9128
    @technicalknowledge9128Ай бұрын

    I need ur help one Google sheet creation and some custom column creation can I share Excel format same format need Google sheet pivot base

  • @OrHaemetElad
    @OrHaemetEladАй бұрын

    Thank you! How i can show in this project pic from google drive?

  • @ashtonfei
    @ashtonfeiАй бұрын

    Try this 1. Make the image file public. 2. Get the file id and try to create a URL by the following pattern. drive.google.com/uc?id=fileIdHere

  • @elementalacer1732
    @elementalacer1732Ай бұрын

    Oh… that’s why it’s named that.

  • @user-hk2jb2js4v
    @user-hk2jb2js4vАй бұрын

    thanks

  • @nickdimuzio4629
    @nickdimuzio4629Ай бұрын

    Hi Ashton. I have a question for you. For Payroll, we print off all of the emails relating to that payroll and then give all of the print outs to our financial director. I am trying to figure out a way to use Apps Script to automatically create pdfs from each email instead so I can then print them all at the same time. Right now, I tag all of the emails in gmail so I can access them that way. For example, I would have all of the emails for this pay period be under the "Payroll 5/1/24-5/15/24" tag. I open up each email and then click on the 'Print all' icon (once you open an email in the gmail ui, the 'Print all' icon is located in the top right part of the email, right below the arrow to move to the next email) and then print each email. Is there a way to do this through apps script? I can use methods like getBody and getSubject to extract all of the relevant data from the email but that ends up extracting a lot of unnecessary information. For example, each email gets longer and longer as a thread goes on because it will extract the "quoted" text. I haven't found a solution to this and I thought I would ask you because you are so amazing with Apps Script!

  • @totoystone6562
    @totoystone6562Ай бұрын

    tysm sir

  • @nancybella7474
    @nancybella7474Ай бұрын

    Could you please make employee leave management connect with attendance employee connect with salary slip with googlescript? Thank you

  • @ashtonfei
    @ashtonfeiАй бұрын

    Thanks for you comment. I am very familiar with the HR process. If you can provide a workflow of yours, then I can check what I can do with it.

  • @ikpassat
    @ikpassatАй бұрын

    Thanks a lot for this.👏👏👏

  • @varshiniratnaraja4682
    @varshiniratnaraja4682Ай бұрын

    thank you Brother

  • @Quackalott
    @QuackalottАй бұрын

    Aww.. Someone been chassing to many parked cars huh.

  • @escapepeterpan
    @escapepeterpanАй бұрын

    It works! thanks so much

  • @totoystone6562
    @totoystone6562Ай бұрын

    thank you for this sir

  • @8hlg8hlg87
    @8hlg8hlg87Ай бұрын

    😊

  • @ikpassat
    @ikpassatАй бұрын

    Thanks you!!! This tutorial helps me a lot!!!!!😍😍😍

  • @user-xv5mz6bn4l
    @user-xv5mz6bn4lАй бұрын

    😢😢😢😢❤❤❤

  • @khalidzakki863
    @khalidzakki863Ай бұрын

    😢😢😢😢😢😢

  • @giannavittori-mo6qv
    @giannavittori-mo6qvАй бұрын

    Excellent video, from Argentina. You are a genious!

  • @lecaonguyen79
    @lecaonguyen792 ай бұрын

    Please, show me how to get data colleges in sheet name dropdown. Thank you so much!

  • @user-fm1jl5cl6b
    @user-fm1jl5cl6b2 ай бұрын

    ❤❤❤❤❤❤❤❤❤

  • @MaksimKlocnkov
    @MaksimKlocnkov2 ай бұрын

  • @user-fm1jl5cl6b
    @user-fm1jl5cl6b2 ай бұрын

    😮