Convert Periscope-formatted hyperlinks to Google Sheets format.
Works with:
No reviews
222
Overview
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)
Additional information
PricingNot available
Developer
Trader status unspecified
SupportNot available
Privacy policy
Terms of service
Periscope Link Converter will ask for the permissions shown below. Learn more
Periscope Link Converter will need access to your Google account
This will allow Periscope Link Converter to :
See, edit, create, and delete all your Google Sheets spreadsheets
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
No comments
Search
Clear search
Close search
Google apps
Main menu