[Youtube]Subscribe, get video title and input it to a Spreadsheet

Discussions and Tech Support related to website data extraction, screen scraping and data mining using iMacros.
Forum rules
iMacros EOL - Attention!

The renewal maintenance has officially ended for Progress iMacros effective November 20, 2023 and all versions of iMacros are now considered EOL (End-of-Life). The iMacros products will no longer be supported by Progress (aside from customer license issues), and these forums will also no longer be moderated from the Progress side.

Thank you again for your business and support.

Sincerely,
The Progress Team

Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the search box (at the top of each forum page) to see if a similar problem or question has already been addressed.
3. Try searching the iMacros Wiki - it contains the complete iMacros reference as well as plenty of samples and tutorials.
4. We can respond much faster to your posts if you include the following information: CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST
Post Reply
gdkdi
Posts: 2
Joined: Thu Feb 28, 2019 7:31 am

[Youtube]Subscribe, get video title and input it to a Spreadsheet

Post by gdkdi » Thu Feb 28, 2019 7:51 am

Hi guys

I have to do this following task
* I have a list of Youtubers (in a Google Drive spreadsheet)
* The spreadsheet has 3 columns ( Channel URL, Video Title, Video URL)
* Visit each of them
* After visit, subscribe to their channel
* Then, pick title and URL from a video of their channel
* And fill that info (title and URL) back to the spreadsheet

I tried recording using iMacros but have had no result so far.

Each time I run the code, it still go to first cell of the spreadsheet, and it can't copy/paste the title and URL of the video :(

Here's the script from the recorded action

====

Code: Select all

VERSION BUILD=10021450
URL GOTO=https://docs.google.com/spreadsheets/d/myspreadsheetexample

TAG POS=2 TYPE=SPAN ATTR=TXT:Open<SP>link
'right-click the cell and choose "open link" in Google Spreadsheet

TAG POS=1 TYPE=YT-FORMATTED-STRING ATTR=TXT:Subscribed<SP>*
WAIT SECONDS=2

TAG POS=14 TYPE=A ATTR=ID:video-title
TAG POS=1 TYPE=H1 ATTR=TXT:*
TAB T=1
TAG POS=2 TYPE=DIV ATTR=TXT:Separator:
===

i'm using iMacros for Firefox (v 10.0.2.1450)
Firefox version 65.0.1

Thank you so much in advance
chivracq
Posts: 10301
Joined: Sat Apr 13, 2013 1:07 pm
Location: Amsterdam (NL)

Re: [Youtube]Subscribe, get video title and input it to a Spreadsheet

Post by chivracq » Thu Feb 28, 2019 8:49 am

gdkdi wrote:
Thu Feb 28, 2019 7:51 am

Code: Select all

iMacros for Firefox (v 10.0.2.1450) 
Firefox version 65.0.1 
Hi guys

I have to do this following task
* I have a list of Youtubers (in a Google Drive spreadsheet)
* The spreadsheet has 3 columns ( Channel URL, Video Title, Video URL)
* Visit each of them
* After visit, subscribe to their channel
* Then, pick title and URL from a video of their channel
* And fill that info (title and URL) back to the spreadsheet

I tried recording using iMacros but have had no result so far.

Each time I run the code, it still go to first cell of the spreadsheet, and it can't copy/paste the title and URL of the video :(

Here's the script from the recorded action

====

Code: Select all

VERSION BUILD=10021450
URL GOTO=https://docs.google.com/spreadsheets/d/myspreadsheetexample

TAG POS=2 TYPE=SPAN ATTR=TXT:Open<SP>link
'right-click the cell and choose "open link" in Google Spreadsheet

TAG POS=1 TYPE=YT-FORMATTED-STRING ATTR=TXT:Subscribed<SP>*
WAIT SECONDS=2

TAG POS=14 TYPE=A ATTR=ID:video-title
TAG POS=1 TYPE=H1 ATTR=TXT:*
TAB T=1
TAG POS=2 TYPE=DIV ATTR=TXT:Separator:
===

i'm using iMacros for Firefox (v 10.0.2.1450)
Firefox version 65.0.1

Thank you so much in advance
'Free'/'PE' is missing from your FCI... => 'Free' I reckon...?
+ OS is missing also, even if it shouldn't play a role in this Case...

I won't help you for the YT part as I don't help for Social Media and Like/Follow/Comment/Subscribe/etc..., but OK for the GoogleDocs/Sheets part...

And hum-hum...!, => "Each time I run the code, it still go[es] to [the] first cell of the spreadsheet, and it can't copy/paste...", ooooh!, yep indeed..., last time I did some Testing in some GoogleSheet on FF with iMacros for FF, that was a bit of a hassle indeed with the Script only going to the 'A1' Cell, and I had to resort to using the 'EVENT' Mode with Keyboard Navigation + Copy&Paste (to/from Clipboard) to get the Script to work...
But the 'EVENT' Mode is not supported anymore/yet in v10.0.2 for FF, oops...!, so that won't be an Option for you... :shock:

I "understood" that GoogleDocs/Sheets work "better" in Chrome and therefore with iMacros for CR also, than in FF and with iMacros for FF, (I don't use CR myself...), so that could be an Option for you if you can give CR and iMacros for CR (=> v10.0.5) a try...
(And the 'EVENT' Mode is also supported in v10.0.5 for CR, if that was needed..., although I'm not sure that would really help as I think the 'KEY' Parameter (needed for the Keyboard Arrows) and the 'MODIFIERS' Parameter (needed for the 'Ctrl^[a|c|x|v]' for the Select/Copy/Cut&Paste are both not supported on CR, oops...!)

And if you can share some public Test GoogleSheet (in Read+Write Mode), I can otherwise have a look if I can find a way to get iMacros for FF to work with it without using the 'EVENT' Mode...
- (F)CI(M) = (Full) Config Info (Missing): iMacros + Browser + OS (+ all 3 Versions + 'Free'/'PE'/'Trial').
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...
gdkdi
Posts: 2
Joined: Thu Feb 28, 2019 7:31 am

Re: [Youtube]Subscribe, get video title and input it to a Spreadsheet

Post by gdkdi » Thu Feb 28, 2019 10:51 am

Hi chivracq

Thanks for your reply

Here's the URL of the Google test file : https://docs.google.com/spreadsheets/d/ ... sp=sharing

I'm using a trial version of iMacros( 12.5), Windows 10 64-bit , and a iMacros plugin for FIrefox.

Please tell me if you need more information
Post Reply