Automators 3: Sal Soghoian uses AppleScript to turn a Numbers Sheet into a Keynote Chart

In the third episode of Automators we are joined by Sal Soghoian, AppleScript God, to learn about AppleScript and how to use it!

While David and I usually take it in turns to write up everything about the show and provide complete documentation, Sal’s actually done that for this week:

You can find the scripts, videos, and a complete breakdown of everything over at macOSautomation, along with all of Sal’s other things.

In this show Sal gave us 3 AppleScripts. The first takes a whole table, and converts it into a bar chart in Keynote, the second takes a row or column and makes a pie chart, and the final one takes selected rows and turns them into a chart.

Q1 Q2 Q3 Q4
Widget A $1212 $1495 $1170 $1423
Widget B $1902 $2345 $1835 $2121
Widget C $2636 $3250 $2542 $3168

The brilliance of this, is the first script is just 17 lines – that’s it!

You can listen to the episode over on Relay FM. And make sure to use the code in the show if you want to attend CMD-D Down Home Scripting Bootcamp!