Automatically shorten URLs in Google Sheets with T.LY Link Shortener

Add Google Sheets credential

In the Latenode Credentials panel, add a new credential for Google Sheets. Authenticate with your Google account and grant the necessary permissions to access your Google Sheets.

Configure Google Sheets node

Add a Google Sheets node to your workflow. In the node settings, select the Google Sheets credential you added earlier. Then, configure the input parameters such as the spreadsheet ID, sheet name, and the column(s) you want to monitor for new or updated rows.

Add TinyURL credential

In the Latenode Credentials panel, add a new credential for TinyURL. Enter your TinyURL API key or generate a new one if you don't have one already.

Configure TinyURL node

Add a TinyURL node to your workflow. In the node settings, select the TinyURL credential you added earlier. Map the input data from the Google Sheets node to the appropriate TinyURL node inputs, such as the long URL to be shortened.

Add a JavaScript Code node

Add a JavaScript Code node to your workflow. In the node settings, write a code snippet that takes the shortened URL from the TinyURL node and updates the corresponding row in the Google Sheet with the shortened URL.

// Example JavaScript Code node
async function main(input) {
  const { spreadsheetId, sheetName, rowIndex, shortenedUrl } = input;

  // Use Latenode APIs to update the Google Sheet row
  await googleSheetsApi.updateRow(spreadsheetId, sheetName, rowIndex, { shortenedUrl });
}