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...
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...