With Aircall's Power Dialer, users are now able to export Google Sheets as a CSV and upload the list directly in their Phone app. Alternatively, users can copy and paste numbers from Google Sheets into the Power Dialer in their Phone app. These are the suggested methods as, unlike with CRMs and Help Desks, Aircall's Browser Extension is unable to highlight numbers directly within Google Sheets. Find more information on these processes at: How to Use Aircall's Power Dialer
However, if you would like to use the Browser Extension with numbers listed in a Google Sheet, instead of exporting or copying/pasting, you can utilize this guide to help you achieve a calling campaign via the Publish to Web feature in Sheets.
Quick Tips & Reminders
-
Please keep in mind that there is a 1000 contact limit to upload to The Power Dialer session.
-
Numbers must be in the E.164 format.
-
Select the column -> Format -> Number -> More formats -> Custom Number Format and then type in “+”# and then click Apply.
-
Your default country set from your phone application is applied and cannot be changed during a session.
How to construct a campaign through Google Sheets
-
Open Google Sheets. If you do not have a Google account, you can easily create one.
-
Create a new sheet and put the contact Name and Phone number in the first two columns as shown in the image below:
-
Once you have completed the list, go to File, located in the upper left-hand corner, Share, then select Publish to the Web.
- In the page that pops up, click Publish.
-
Take the link shown here and copy and paste it into a new window in Google Chrome.
-
Make sure that you are logged into the Aircall Browser Extension.
-
Click Add to Power Dialer and begin your session.
⚠️ You can find more information about using Aircall's Browser Extensions here.
Once published, any changes you make to the spreadsheet will also be reflected in the newly published page.