Periscope Link Converter

A Google Sheets Addon to convert Periscope-formatted hyperlinks to Google Sheets format.

View the Project on GitHub vergenzt/gsheets-periscope-link-converter

Periscope Link Converter

A Google Sheets Addon to convert Periscope-formatted hyperlinks to Google Sheets format.

Installation

  1. Visit the G Suite Marketplace listing.
  2. Click “Install”.
  3. Click “Continue”, choose your account, and grant permission to the app to access and modify your spreadsheets.

Ready to use! ✅

Usage

After installing:

  1. Click Addons > Periscope Link Converter > Convert links in …

    1

  2. See confirmation.

    2

  3. Voilà! Links you can click.

    3

Periscope docs

https://doc.periscopedata.com/article/tables#Hyperlinks

Tables will automatically convert a valid URL string starting with https:// or https:// into a clickable link. A URL can also be labeled to display a clickable name by utilizing the following syntax:

select '[Hyperlink Name](https://www.google.com)'

This query will result in the table shown below:

Periscope - individual hyperlink

This syntax can also utilize data from individual columns to make the hyperlinked name dynamic. The following query uses “First_Name”, “Last_Name”, and “Twitter_Account_URL” columns to build out the link:

Redshift/Postgres:

select '[' || First_Name || ' ' || Last_Name || '](' || Twitter_Account_URL || ')' as Customer

MySQL/SQLServer/BigQuery/Oracle:

select CONCAT('[', First_Name, ' ', Last_Name , '](', Twitter_Account_URL, ')') as Customer

The result is shown below, and clicking each link will open up that user’s twitter page:

Periscope - column of hyperlinks


Privacy Policy