Help with an Applescript to paste from Google Sheets to Numbers
I found a way to copy from Excel to Numbers using the script. I was wondering what options are available for google sheets. I have the web address that hosts an example data that I'd want to copy A1:G1
Here is the apple script I have working to copy/paste from excel. I'm not strong on website parsing.
set tgtTable to "Copy/Paste" -- change if needed to match table name
set pasteCell to "a1" -- upper left cell of range to place values
tell application "Microsoft Excel"
activate
select worksheet "Sheet1"
select range "a1:h1" of worksheet "Sheet1"
tell application "System Events" to keystroke "c" using command down
tell application "Microsoft Excel"
end tell
tell application "Numbers"
tell front document's active sheet's table tgtTable to set selection range to range pasteCell
activate
delay 0.2 -- vary this if needed
end tell
tell application "System Events" to keystroke "v" using {option down, shift down, command down}
end tell
to getVal(t, valTag)
set text item delimiters to valTag
set item2 to t's text item 2
set text item delimiters to "\" "
set val to item2's first text item
end getVal
iPhone 6s Plus, iOS 10.0.1