- 410
- 443 202
Ashton Fei
Hong Kong
Приєднався 21 чер 2011
Hey everyone, this is Ashton!
I'm doing this video log as a personal learning project to document my journey with Google Apps Script. It all started back in 2017 when I first came across Google Apps Script while working at Lexmark. Ever since then, I've been sharing the projects I've built for two main reasons: to get better at speaking English and to keep track of my progress as I learn.
🧑🏻💻 Automate the Boring
- Automation solutions for Google Sheets, Slides, Docs, Gmail, Calendar, Drive, and more.
- Development of add-ons for Google Workspace and Editors.
- Optimization and automation of business processes.
- Data analytics and insights.
- Reporting with Looker Studio (Data Studio) and Google Sheets dashboards.
- Creation of custom forms using Google Apps Script.
- Development of lightweight web apps with Google Sheets as the database.
- Integration of third-party APIs with Google Apps Script.
ashtonfei.blogspot.com/
I'm doing this video log as a personal learning project to document my journey with Google Apps Script. It all started back in 2017 when I first came across Google Apps Script while working at Lexmark. Ever since then, I've been sharing the projects I've built for two main reasons: to get better at speaking English and to keep track of my progress as I learn.
🧑🏻💻 Automate the Boring
- Automation solutions for Google Sheets, Slides, Docs, Gmail, Calendar, Drive, and more.
- Development of add-ons for Google Workspace and Editors.
- Optimization and automation of business processes.
- Data analytics and insights.
- Reporting with Looker Studio (Data Studio) and Google Sheets dashboards.
- Creation of custom forms using Google Apps Script.
- Development of lightweight web apps with Google Sheets as the database.
- Integration of third-party APIs with Google Apps Script.
ashtonfei.blogspot.com/
Compress Uploaded Images in Google Forms to Save Your Drive Space: GAS112
Compress Uploaded Images in Google Forms to Save Your Drive Space: GAS112
Переглядів: 161
Відео
Easily Import CSV Data into Google Docs and Slides: OneScript
Переглядів 14021 день тому
Easily Import CSV Data into Google Docs and Slides: OneScript
Export Multiple Gmail Threads as PDFs or One Single PDF: GAS111
Переглядів 155Місяць тому
Export Multiple Gmail Threads as PDFs or One Single PDF: GAS111
Responsive Table & Image | Embed YouTube Video & Playlist | JS & CSS: Easy Blog Update 1
Переглядів 232Місяць тому
Responsive Table & Image | Embed UA-cam Video & Playlist | JS & CSS: Easy Blog Update 1
Turn Google Docs into Google Blogger Posts and Pages with Easy Blog: OneScript
Переглядів 126Місяць тому
Turn Google Docs into Google Blogger Posts and Pages with Easy Blog: OneScript
Easily Update Placeholders on Google Docs and Slides: OneScript
Переглядів 84Місяць тому
Easily Update Placeholders on Google Docs and Slides: OneScript
Export to and Send as DPF, Word, Excel, and PPT in Google Drive: OneScript
Переглядів 176Місяць тому
Export to and Send as DPF, Word, Excel, and PPT in Google Drive: OneScript
Easy Tabs (Delete/Hide/Color/Sort) | Google Map Image in Google Sheets: OneScript
Переглядів 141Місяць тому
Easy Tabs (Delete/Hide/Color/Sort) | Google Map Image in Google Sheets: OneScript
Custom Shapes & Groups | Grid Shapes | Google Map Image in Google Slides: OneScript
Переглядів 84Місяць тому
Custom Shapes & Groups | Grid Shapes | Google Map Image in Google Slides: OneScript
Any Page Size | Bionic Reading | Google Map Image in Google Docs: OneScript
Переглядів 66Місяць тому
Any Page Size | Bionic Reading | Google Map Image in Google Docs: OneScript
Create Sequential Repeat Events Easily in Google Calendar: OneScript
Переглядів 113Місяць тому
Create Sequential Repeat Events Easily in Google Calendar: OneScript
Simplify Group Emails with MailScript for Gmail: OneScript
Переглядів 82Місяць тому
Simplify Group Emails with MailScript for Gmail: OneScript
OneScript - Streamline Your Google Workspace Tasks Effortlessly
Переглядів 389Місяць тому
OneScript - Streamline Your Google Workspace Tasks Effortlessly
Insert Signature to Docs and Sheets: Chalkline V1.20
Переглядів 1862 місяці тому
Insert Signature to Docs and Sheets: Chalkline V1.20
Custom Page Size in Google Docs: Chalkline V1.19
Переглядів 1252 місяці тому
Custom Page Size in Google Docs: Chalkline V1.19
Merge Multiple Google Docs into One: GAS110
Переглядів 2692 місяці тому
Merge Multiple Google Docs into One: GAS110
Free Solution for Doc Sign with Google Forms, Docs, Sheets, and Gmail: GAS109
Переглядів 4912 місяці тому
Free Solution for Doc Sign with Google Forms, Docs, Sheets, and Gmail: GAS109
Employee Profile App with Data from Sheets: GAS108
Переглядів 5923 місяці тому
Employee Profile App with Data from Sheets: GAS108
Join & Split Rich Text Values In Google Sheets: GAS107
Переглядів 1884 місяці тому
Join & Split Rich Text Values In Google Sheets: GAS107
Add View Count to Your Blogger Posts : GAS106
Переглядів 4545 місяців тому
Add View Count to Your Blogger Posts : GAS106
Create Gmail Replies or Drafts with ChatGPT Automatically: GAS105
Переглядів 5177 місяців тому
Create Gmail Replies or Drafts with ChatGPT Automatically: GAS105
Create Nested Menu Structure for Google Sheets, Docs, Slides, and Forms: LC022
Переглядів 3277 місяців тому
Create Nested Menu Structure for Google Sheets, Docs, Slides, and Forms: LC022
Add Validations to Prompts in Google Sheets: LC021
Переглядів 2488 місяців тому
Add Validations to Prompts in Google Sheets: LC021
Copy & Update Google Apps Script to Multiple Files: GAS104
Переглядів 5738 місяців тому
Copy & Update Google Apps Script to Multiple Files: GAS104
Apply Bionic Reading to Your Google Documents: Chalkline Docs
Переглядів 1 тис.8 місяців тому
Apply Bionic Reading to Your Google Documents: Chalkline Docs
Monitor File Updates on Google Drive with Google Apps Script: GAS103
Переглядів 4708 місяців тому
Monitor File Updates on Google Drive with Google Apps Script: GAS103
Debounce OnEdit Event with Apps Script in Google Sheets: LC020
Переглядів 572Рік тому
Debounce OnEdit Event with Apps Script in Google Sheets: LC020
Booking & Cancellation with Google Calendar & Forms: GAS102
Переглядів 1,2 тис.Рік тому
Booking & Cancellation with Google Calendar & Forms: GAS102
Preview: Booking & Cancellation in Google Calendar by Google Forms
Переглядів 311Рік тому
Preview: Booking & Cancellation in Google Calendar by Google Forms
Easily Update YouTube Titles & Descriptions in Multiple Languages: GAS101
Переглядів 238Рік тому
Easily Update UA-cam Titles & Descriptions in Multiple Languages: GAS101
سلام
🙏🙏🙏
One cannot use development mode anymore - only the released versions which also must be updated manually in the destination project
Is it possible to to bulk edit your blogger post content using google sheet?
Yes, it's possible, I fixed my posts in this way. However, it's not easy to make it usable for everyone.
thank you so much . great work
Can this be used to create a dashboard? I want to be able to have a filter option, which can then change the graph
🥰
Are they from the same litter??
No, same breed with similar colors.😅
Awwwwwwwww
I tried to to copy graphql library code from github and searched in apps script libraries. It could not be found. Can you please provide the libarary.
Thanks a Lot Ashton Fei Sir, All working even add 3 level of approval
can you help me, i Cant try to copy and make the form, but cannot get the approval in my email
good pl create a trigger for auto posting from provided list of products is in google sheet
Yes, we can. That will need more customization depending on your how complex of your product info and post template.
@@ashtonfei i already created posts. now just need to auto post from googlesheet one by one all rows
Please can u create google sheet script to share blogger post to social media plateform. Eg facebook twiter pintest
Create google sheet scrpit bloger automatic post share to different social media plateform. Eg fb insta pinterstest twiter and other
Please create a progect for payments gateways
🎉nice work
Absolutely adorable 🥰😍
Hello there. You have nice projects. There are a few projects I want to have done. I tried to reach you at gmail but I didn't get a response. How can I reach you to share the scenarios of the project?
Sorry, I might take your email as spam.
My fave time of day!
So cute 😍
❤❤❤❤❤❤❤❤
Very useful. Thanks a lot
is there a way i can create folder by date(daily folder by date )
Do you know if there is a way to use a script to download all of the emails with a certain Gmail tag into PDFs? I currently have to click Print for each email but I would like to download the emails as PDFs in bulk
Thanks for the feedback, do you need to print the image on the email? If it's only for the text on the email body, I think I may have a solution.
@@ashtonfei I would like to print the images on the email as well
@@nickdimuzio4629 Noted, will do some tests and let you know.
@@ashtonfei Thank you!
Check this out 👉 ua-cam.com/video/tzDkQGKRSPc/v-deo.html
So cute 😍 💓 💗 ❤
Looks like sleepy time!
how can i change the picture and request note change into many option category such as leave,receiving or others
I really appreciate your video and the files you shared! Thank you so much!! Can I ask also, Is there a limit on the size of google docs? I have this prompt when trying to merge "Too many changes applied before saving document. Please save changes in smaller batches using Document.saveAndClose(), then reopen the document with Document.openById()." Thank you again!
Hmm, I didn't do any pressure test. The core logic is looping the documents and keep appending the paragraphs to the target document one by one. If you got that error, yes, execute the saveAndClose method after one document then reopen the target document for the next one.
good video 😀, can you update the copy link, please?😁
You had any issue with this link? docs.google.com/spreadsheets/d/1Vd1q1z_-qzEGIdVJIX9N3GYpT_Vla4bfhF3_7ME8Chk/copy
Nếu thêm phần giá trị của từng sản phẩm thì phải thêm ntn bạn nhỉ?
Is it possible to see the source code for this please?
Sorry, I don't have a plan to make it public recently. If you are interested in this "Signature" feature, you can check this video. It's a similar one. ua-cam.com/video/nQV5r_WOVw4/v-deo.html
@@ashtonfei I understand. I am general trying to figure out how you get the modal in Google Docs where the user would then sign. Is there any code you can share on that feature?
Very nice script man. How are you making the drawing / image?
The canvas element was used for the drawing and this library is used to simplify the work. github.com/szimek/signature_pad
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