Create Bitlinks from a CSV file in bulk and add them to a Google Sheet

First, we need to connect EasyCSV, Bitly and Google Sheets to IFTTT.

• 

  Create IFTTT account.

  Create IFTTT account if you don't have one.

• 

  Connect EasyCSV to IFTTT.

  Give IFTTT access to your EasyCSV account, using EasyCSV credentials.

• 

  Connect Bitly to IFTTT.

  Give IFTTT access to your Bitly account, using Bitly credentials.

• 

  Connect Google Sheets to IFTTT.

  Give IFTTT access to your Google Sheets account, using Google Sheets credentials.

Next, we need to create a workflow automation scenario using graphical no-code web interface of IFTTT.

• 

  Set up a Trigger action for EasyCSV

  Choose the following trigger: New Row Importing from a CSV or Google Sheet (This trigger fires for each row being imported from a CSV file or Google Sheet.).

• 

  Then set up an Action for Bitly

  Choose this action: Add a bitlink (This Action will shorten and add a new bitlink to your bitly account.).

• 

  Then set up another Action for Google Sheets

  Choose this action: Add row to spreadsheet (This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.).

Finally, we need to test this automation and publish it.

• 

  Customize data flow

  Configure the data that is exchanged between EasyCSV, Bitly and Google Sheets.

• 

  Test the workflow and turn it on for production use

  Test your scenario and publish to production. Now you have an automatic workflow, that will Create Bitlinks from a CSV file in bulk and add them to a Google Sheet!