Query Public Sheet
Google Sheets by donpinkus
UPDATE 2018: To use Google Sheets as a database, use Blockspring Pages: https://open.blockspring.com/pages.
Slack Integrations: Connect your Slack with 150+ apps and automate your workflow instantly. Integrate Slack with Appy Pie Connect without coding. Looking for an easy spreadsheet integration? Try Formsite's Google Sheets integration & send form results to a Google spreadsheet. Learn more today! How Microsoft Excel + Slack Integrations Work Step 1: Authenticate Microsoft Excel + Slack. ( 30 seconds) Step 2: Pick one of the apps as a trigger, which will kick off your automation. ( 15 seconds) Step 3: Choose a resulting action from the other app. ( 15 seconds) Step 4: Select the data you want.
Slack Spreadsheets
This block will query a public Google Spreadsheet, and return the results as JSON.
Remote desktop services. Instructions
1. Enter the URL for your Google Spreadsheet.
- You'll need to make your spreadsheet publicly shareable. Click the 'Share' button, then 'Advanced', then 'Change', then 'On - Anyone with the link', then 'Save'.
- Copy/paste the URL Google gives you right into the form below.
1. Enter the URL for your Google Spreadsheet.
- You'll need to make your spreadsheet publicly shareable. Click the 'Share' button, then 'Advanced', then 'Change', then 'On - Anyone with the link', then 'Save'.
- Copy/paste the URL Google gives you right into the form below.
Slack Paste Spreadsheet
![Slack Spreadsheet Slack Spreadsheet](/uploads/1/1/9/8/119875885/256304123.gif)
Slack Share Spreadsheet
2. Enter a query.
Murus pro. This is very similar to SQL but with some differences. The primary difference is instead of column names, you use the Column Letter (A, B, C, D, etc). Here is Google's documentation for more info.
Murus pro. This is very similar to SQL but with some differences. The primary difference is instead of column names, you use the Column Letter (A, B, C, D, etc). Here is Google's documentation for more info.
** Note - this function assumes the first row of your spreadsheet has headers. Also, Google has some strange issues here. Your first row of data needs to have at least 1 number, and you cannot have any columns of timestamps.
1
2
Setup Your Connector
Results
Slack Excel Spreadsheet
3