Hi RWessels,
You can start with browser automation guide, as you are using Google sheets, you will have to create a business object which will take care of all online work, once you are done with that part, you can use Blueprism provided utility - File Management to create the folder and rename it.
You can use SMTP/POP3 object to send mail via gmail, you can find videos on youtube as well for that part.
Hope it will help you.