Google Sheets is an instrument for creating tables, charts and graphs. The advantage is that you may share a document for joint usage with your colleagues.

Note: Google Sheet is a handy way to view all the changes that have occurred in document.

Short.io & Google Sheets Zap creates short links for the long URLs in the rows. If somebody edits an existed long link or adds a new one, a short link will be created with the changes.

One more way to use Short.io & Google Sheets Zap is for bulk link creation. Turn on a Zap and paste a list of long links to the sheet. A list of shortened links will appear in your Short.io account.

Note: To configure this Zap, you need to have at least a one long link in a Google Sheet row.

Straight to the video guide or follow the instruction.

1. Go to Zapier.

2. Choose Make a Zap.

make-zap.jpg

3. Search for Google Sheets and click its icon.

google-sheets.jpg

4. Choose "New or Updated Spreadsheet Row" event. Continue.

new-row.jpg

5. Connect your Google Sheets account. When you click connect, you need to log into Google account.

connect-gsh.jpg

6. When your account is on, continue.

7. Fill in necessary fields. Continue.

fill-fields-gsh.jpg

8. Pick a sample of the row to test.

9. Now you need to add an action. Search for Short.cm and click its icon.

gsh-cm.jpg

10. Choose the action and continue.

11. If you configure this Zap for the first time, you need to connect Short.cm account.

conn-gsh.jpg

12. Go to your Short.io account or https://app.short.io/settings/integrations/api-key

13. Open User Menu.

user-men.jpg

14. Choose the "Integrations & API" tab.

integrations.jpg

15. Copy API key.

shortcm-api-key.jpg

16. Paste API key to connect Short.cm account. Continue.

pate-api-key.jpg

17. When account is on, continue.

18. Fill in necessary fields to send a short link. Continue.

fill-fields-gsh-sh.jpg

19. Send a test to make sure you've made a correct setup.

Important: Turn on your Zap.

Video Guide

The video guide helps to correctly customize the Short.io & Google Sheets Zap .

Did this answer your question?