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

https://vergenzt.github.io/gsheets-periscope-link-converter

## Usage:

1. Click Addons > Periscope Link Converter > Convert links in ...
2. See confirmation.
3. Voilà! Links you can click.

## Periscope docs

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

> ### 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](https://web.archive.org/web/20191114213951im_/https://assets.website-files.com/58fe8f93dc9e750ca84ebb16/599f359c2a72ab0001f6fc8f_tables7.png)
> 
> 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](https://web.archive.org/web/20191114213951im_/https://assets.website-files.com/58fe8f93dc9e750ca84ebb16/599f35abec00ea00014fbc99_tables8.png)