🧑🏻💻 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/
Пікірлер
thank you so much sir
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?
How can the cat breathe with such a deformed face? Poor thing.
He has some issues with eating so I am helping to feed him.🥹
Very sweet
My side is not working. Can you help me
I can't thank you enough Mr. Ashton .. Please, keep sharing like these projects with us :)
file Not Found Error 404
file Not Found Error 404
Dai, una carezza è bella... 😅
how to link the new form with the sheet you show? When creating a new form, it creates another sheet
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.
@@ashtonfeiExcelente, tenía que colocar el mismo nombre de la hoja principal 🎉🎉🎉🎉🎉 muchas gracias
Is there a way for the email to be sent to more people and once they all sign, the document is generated?
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.
@@ashtonfei Ojalá puedas realizarlo algún día. Gracias 🫂
Excelente
❤❤❤
Cuteness overload 🥰🥰🥰🥰🥰🥰
It works
I have added Drive API. Why does this error still happen? TypeError: Drive.Files.insert is not a function
Check the api version, if it’s v3 then change it to v2. I may use the old version when I created the project.
@@ashtonfei Thank you so much
Cute cat
im the first comment ever on this vid
Nice
Is a cute little grumpy cat I love it
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)
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
@@ashtonfei I tried again, it only worked on personal channels attached to gmail, brand channels were not effective.
@@ashtonfei can you fix it
@LofiZ-gr7ce Unfortunately, I only have the personal account to test.
Hello , thanks for your tips, i have an error to start initialize ...
Form submission doesn't trigger the function. Is it needed to create a trigger function for form submission?
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.
Ohhh 🫢 first cat is ugly
😘😘😍😍😍😍😍
❤❤❤❤❤❤
Amazing, you are the best.
i very like this code can i have this script please!!!
You should be able to find the link in the description.
That is surely one distinguished individual in their natural habitat!❤
My cat does the same 😄
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
Will these tasks be created all in your account? Or you will need to create them for your clients and the coaches?
@@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.
@@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; }
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
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
Thank you! How i can show in this project pic from google drive?
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
Oh… that’s why it’s named that.
thanks
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!
tysm sir
Could you please make employee leave management connect with attendance employee connect with salary slip with googlescript? Thank you
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.
Thanks a lot for this.👏👏👏
thank you Brother
Aww.. Someone been chassing to many parked cars huh.
It works! thanks so much
thank you for this sir
😊
Thanks you!!! This tutorial helps me a lot!!!!!😍😍😍
😢😢😢😢❤❤❤
😢😢😢😢😢😢
Excellent video, from Argentina. You are a genious!
Please, show me how to get data colleges in sheet name dropdown. Thank you so much!
❤❤❤❤❤❤❤❤❤
❤
😮