วีดีโอ

I got a lot of comments with other apps script videos saying I was making thing way too complicated, love this comment thanks a lot

@analyticswithadam haha, heck no man 😂. You simplified it to anyone who wants to understand what's happening. I guess they are annoyed by "over explaining"? I think that's awesome, discussing intricacies, maybe other peeps just want the end result rather than understanding the process and methodology? 🤷 Idk, I prefer your style to be honest. Lots a love mate 💯😎

Glad to hear it

Yes you can I do that in my role

No worries!

There is a version control in apps script where you can restore a previous version it's in project history here is a link to the instructions developers.google.com/apps-script/guides/versions

You need to add data somewhere on Google Cloud whether it be cloud buckets or big query itself. If you just want to learn there are a lot of public data sources on Big Query already.

You can also throw the comment in to an AI chatbot to summarise and give you the sentiment. Cuts through the spam

Hi Ali, I have a M2 - I ended up deleting it and buying a cheap windows laptop

I’m using the TH-cam API this video show how to get comments How to Extract TH-cam comments in sheets and analyse with AI with 1 click th-cam.com/video/1KwFFb_tofY/w-d-xo.html

Amen

Data through an API is not scraping . It’s only when you circumvent controls on a site

It’s still possible but there is a charge now

or it just only scrape the top comments? Thanks before

I have a couple of video on this . This method gets comments and replies

I do not, am starting a discord to answer questions

No worries, a load more App Script videos coming where I go through the basics from scratch.

@analyticswithadam This and your ranges video was all I needed as an introduction. With some help from LLMs the projects I wanted to make is done and I don't have future plans that involve app script, but thanks. 🙂

There is a limit on the amount of requests you can do in a day of 10,000. Believe you need to do one request per page which is about 100 comments. so 1,000,000 per day.

Start of this one, it is still working. th-cam.com/video/SIm2W9TtzR0/w-d-xo.html

Add three lines of code at the end. Im assuming you are using Google Colab from google.colab import files df.to_csv('my_data.csv', index=False) files.download('my_data.csv')

It could be your version of Excel. What version are you using? Is it free or paid? Mac or Windows? Company or Personal?

Skip them on the for loop

@@analyticswithadam I managed to figure it out, but still, thankyou for the reply!

@@libyanmapping5408 glad it worked for you 🙌

Awesome

I’m using a standard paid version on PC

It’s saved to the colab instance you can download it to your PC or save it to your Google drive from there .

Happy Christmas

What did you research?

Excel on Mac is not great. Had this issue myself trying to extract xml file. One click on windows pain in the ass on Mac.

Thank you for the feedback…I would apply that to specific columns not the entire dataset.. whatever meets the need I suppose but a thousand ways to do everything with ML… what are you building at the moment ?

@@analyticswithadam I am currently learning at the moment. I have a car insurance dataset that has a lot of categorical variables, and I'm wondering how the dummie or OneHot encoding will make the dataset look like afterwards.... hahaha

@@everythingisright There are so many variables with insurance and bank loan datasets. Best of luck with it

Not yet .. Udemy is a good place to learn would recommend Leila Gharani’s sheets course . They normally run $10 sales. Start with that then SQL then Dashboard tool

@analyticswithadam Thanks

Glad if helped Chief

ChatGPT is a great resource to debug, not 100% but much better than searching online

What are you having problems with?

@@analyticswithadam "I'm a senior high school student and I'm just starting out with App Scripts. I'm working on a research project and could really use some help creating an App Script. Would you be able to guide me through the process?"

@@analyticswithadam Here is the layout: Columns: Column 1 ("Student ID"): Identifies each student with a unique number. Column 2 ("Student Name"): Provides the name of the student. Columns 3-18 ("Subject 1 - Subject 9"): Track attendance for each subject. Each subject has two columns - "Time In" and "Time Out" - to record when the student entered and left the class. Column 19 ("Attendance Status"): This column is likely used to determine if the student is present, late, skip, or absent. Rows: Each row represents a student. The first column (labeled "Student ID") identifies each student with a unique number which is the RFID card. The second column ("Student Name") tells us the name of the student corresponding to that row. The remaining columns (Subject 1 through Subject 9) track the student's attendance in each subject.

@@RadenReynaldo Have go writing the code with ChatGPT and if you are having any specific issues I can help.

A test planning or something like that and thx for u work now i understand more what to do with it

@@MauriceKeijzer-p3c Loads of videos coming in the coming weeks that build on this one

Hey Piotr , This AI field is moving really fast with products. Now you can get structured output with Google AI studio then export the code from there. Probably better than this method.

No limit

@analyticswithadam i try run code to import gmailes to google sheet, i setup triggar to run every 5m after 12hours i got error message because of limit times run. By the way im from syria. Is that make limit about times to run code on Google script

@@khabbazz89 Apologies, I was wrong. Two limits, 1000 api executions per day and sending 100 emails... While your 5 min trigger is only 288 execution per day unless you are calling each mail as 1. Have you anything else running that might be pumping these API calls up on your account?

@@analyticswithadam i've another question can i host telegram bot on app script so still answer users (/start) and aprommot bot commands?

@@khabbazz89 I don't think so it mainly interacts with Google Tools. Im sure you could pull data from a Telegram API but not host anything