I want to get the text contained within a specific cell of my Excel Spreadsheet

Problem:

I want to get the text contained within a specific cell of my Excel Spreadsheet

Solution:

Discussion:

We need to launch the excel file, and get the first free row and column via data extraction, so that we can use it in Action 3 where we will retrieve the values of our excel table and store them in our data table. Since we do not know how many columns or rows are used in our excel spreadsheet, we shall use the %FirstFreeColumn% and %FirstFreeRow% variables to define the last used column and row, since the first free column and row are obviously empty, this means that the column and row prior to them are filled in with data.

Get all Tweets & Retweets of a User including Date and User Retweet Details

This functionality will require installation of the free Twitter Addon!

Problem:

Get all Tweets & Retweets of a User including Date and User Retweet Details

Solution:

Discussion:

In order to get all the Tweets and Retweets a User has done and store them to a text file with a datestamp, all we have to do is use the Twitter Addon and build our very own Twitter API. We first login to twitter using the “Specify Twitter Account” action, and get all the Tweets of the User, and then continue to get the Retweets the User has done.

We use the “Get Twitter User Timeline” action to retrieve the User’s timeline, that would be a list containing all User’s Tweet activity.

I want to download a list of webpages without opening any browsers and save their contents

Problem:

I want to download a list of webpages without opening any browsers and save their contents in a date-stamped Folder

Solution:

Discussion:

To start with, we create a list of all the websites we want to be scraping, and save them in a txt file. We then continue by getting the current date and time, and convert it to text using a format that we can use to name a folder after, and then, using the “For Each” action, we run a number of actions for each website on that list. We first run the “Download from Web” action, which we configure to use the %CurrentSite% each time, and download the page, saving it in the %WebPageText% variable.

I want to send an email to multiple recipients using the contacts’ information found in my Excel Spreadsheet

Problem:

I want to send an email to multiple recipients using the contacts’ information found in my Excel Spreadsheet

Solution:

The following job describes how one can use the information retrieved from a contact list, to be used to send an email to each member of the list, using their details, creating a more personalized email and sending it off to each recipient.

Discussion:

We start by launching our Excel file, and start the data extraction by getting the first free row and column. This will help us determine which is the last row and column used to set the margins of our data table in the next action.

I want to get the name of each file contained in a folder and append all its properties (creation date, size, etc) to an Excel file

Problem:

I want to get the name of each file contained in a folder and append all its properties (creation date, size, etc) to an Excel file

Solution:

The job displayed above will create a list of each file contained within our specified folder, and append the file name.

Discussion:

To start with, we use the “Get the Special Folder” to represent our Desktop. This way no matter on which machine we run this job, it will always work.

We use the “Get Files in Folder” action that will give us as an output a variable of type list. This list will hold all the files contained within our folder.

Copyright 2017 - Softomotive Ltd