OROLOGIO POP UP DENTRO GOOGLE SHEET . Salve, un cliente mi ha chiesto di poter inserire dentro una cella google sheet l'orario di inizio di lavoro dei suoi dipendenti . la persona deve poter inserire un orario che vada dalle 8 di mattina alle 8 di sera in slot di 5 minuti, ho pensato al menu a tendina ma viene una cosa enorme, ho collegato google moduli al google sheet ma nel google moduli quando si inserisce lora non compare l'orologio , invece quando si clicca sulla data appare il calendario, ecco vorrei una cosa cosi, sapete come posso fare? . vorrei inserire un pop up che faccia apparire un orologio al clic , sapete come? grazie mille spero di essermi spiegato
I need help with my business please. We make posts with many different accounts (every time new accounts) on Instagram, TikTok, Facebook and RUclips. When the post is done, we gather all of them in a google sheet by puting the link of each post in it. Next to it we need to gather the data of each one being: Views, likes, comments, and shares. But it takes so much time to go post by post updating this data every day. Is there a way that I can have this information updated automatically every 1 hour or whatever, by only using the links of the posts?
I'd suggest looking around RapidAPI's Instagram services to see if that's possible. Interms of hourly updating, we do offer hourly updates: mixedanalytics.com/knowledge-base/api-connector-scheduling/
Hi, thanks for the tuto, very helpful. But I have an issue while using the "Query" formula for the dashboard. The pop up is saying "Formula parsing error". Could you please send me the formula you used. :)
@@mms3489 I Just checked the French docs, and it looks like SQL language is universal. Can you paste in your function here so I can take a look? it may be the &SUBSTITUTE() is being wonky
Yo! So if you noticed in RapidAPI's UI, there's a spot that says req.query. That's the same thing as your query parameters (for any API on rapidAPI). If you are typing out query parameters, you would put in the whole endpoint, then use "?username=christian" and then use the ampersand for any more you need to attach. So the generic request would be something like this: www.apiservice.com/v1/endpoint?queryparam1=42&queryparam2=5433
I want to copy data from instagram profile like contact details, username etc. How can i get this copied data in my google sheet is there any way, If yes please make video or reply my comment. It can very helpful for me Please
I am marketer and i am personally going to peoples profiles and checking and scraping their info to my marketing campaigns. So is there any way to those peoples info i can directly get it who wants me.
I am quite disappointed! Why have you not made more videos!!! I checked out this channel and ugh! this one was massively amazing content, helpful!
can i get all off post data from my account, not only 12? coz i need all data from my post
The API is no more available on RapidAPI, do you recommend any alternative please?
Hmm, I sure don't. I'll update here if I come back to it!
Do you have the formula for performing the query on the sheet that i could copy and paste please?
Can I automate with scheduled updating?
OROLOGIO POP UP DENTRO GOOGLE SHEET
.
Salve, un cliente mi ha chiesto di poter inserire dentro una cella google sheet l'orario di inizio di lavoro dei suoi dipendenti
.
la persona deve poter inserire un orario che vada dalle 8 di mattina alle 8 di sera in slot di 5 minuti, ho pensato al menu a tendina ma viene una cosa enorme, ho collegato google moduli al google sheet ma nel google moduli quando si inserisce lora non compare l'orologio , invece quando si clicca sulla data appare il calendario, ecco vorrei una cosa cosi, sapete come posso fare?
.
vorrei inserire un pop up che faccia apparire un orologio al clic , sapete come?
grazie mille
spero di essermi spiegato
Sorry, I tried to translate this but not having a lot of luck. Feel free to drop your idea over on our Reddit Channel: www.reddit.com/r/api_connector/
Hi, thank you so much for sharing.
Can you also share the formula?
I need help with my business please. We make posts with many different accounts (every time new accounts) on Instagram, TikTok, Facebook and RUclips. When the post is done, we gather all of them in a google sheet by puting the link of each post in it. Next to it we need to gather the data of each one being: Views, likes, comments, and shares. But it takes so much time to go post by post updating this data every day. Is there a way that I can have this information updated automatically every 1 hour or whatever, by only using the links of the posts?
I'd suggest looking around RapidAPI's Instagram services to see if that's possible. Interms of hourly updating, we do offer hourly updates: mixedanalytics.com/knowledge-base/api-connector-scheduling/
what i have to do if i want get data starting from an hashtag?
No idea...
Saved finally... Thank you so much...
Glad it helped!
can we generate someones post like ?
Not sure I understand the question, what do you mean?
And can I get the info of each post (views, likes, comments and shares) to update automatically every 5 minutes? How? Thank you!
Not possible to update every 5 minutes, our add-on allows hourly updating
Hi, thanks for the tuto, very helpful.
But I have an issue while using the "Query" formula for the dashboard. The pop up is saying "Formula parsing error".
Could you please send me the formula you used. :)
MAYBE THIS IS BECAUSE I USE THE FRENCH GOOGLE SHEET I DONT KNOW... :/
@@mms3489 I Just checked the French docs, and it looks like SQL language is universal. Can you paste in your function here so I can take a look? it may be the &SUBSTITUTE() is being wonky
You have to check what language you are writing. Some languages works with comma and another with semicolon. You're welcome ;)
What do I do if I am getting invalid user id when i'm trying "get account post"
Hey Andrew!
Parameters can be pretty picky with trailing spaces and so forth, so make sure you didn't slip one in by accident.
Is this only for Instagram? What if i wanna do the same with TikTok and Facebook, is it possible?
Not sure if Tik Tok is available. I've read all 3 comments and will consider for future content. Thanks for the feedback!
where do i set params?
Yo! So if you noticed in RapidAPI's UI, there's a spot that says req.query. That's the same thing as your query parameters (for any API on rapidAPI). If you are typing out query parameters, you would put in the whole endpoint, then use "?username=christian" and then use the ampersand for any more you need to attach. So the generic request would be something like this:
www.apiservice.com/v1/endpoint?queryparam1=42&queryparam2=5433
I want to copy data from instagram profile like contact details, username etc.
How can i get this copied data in my google sheet is there any way,
If yes please make video or reply my comment.
It can very helpful for me
Please
Hi Shubham,
Are you talking about for a personal profile the followers or people you follow?
@@mixedanalytics I am talking about personal rofiles who not following me
I am marketer and i am personally going to peoples profiles and checking and scraping their info to my marketing campaigns. So is there any way to those peoples info i can directly get it who wants me.