-3

I have a Google sheet with 400+ names, emails, and phone numbers that I am calling. I have already written an Apps script that automatically sends mass emails out on the click of a button. I automated mass text messaging through shortcuts on my phone. I've tried using a power dialer app that connects with the phone number I already have on my phone.

Is it possible to write an Apps script that, upon running, it will automatically connect to the phone number I already have, dial the number, and if there is no pick up, I can automatically move on to the next one (similar to a Power dialer)?

I know that when you add =HYPERLINK("https://call.ctrlq.org/"&B2; A2) to a cell in Spreadsheets, you can click to call the number. So I can call through Google spreadsheets, I just want to automate the process so I don't have to manually type in and dial the numbers or click on each one.

In a perfect world, I would want something that I can run off my laptop and it would connect with my phone and call (I do have a windows laptop and an Iphone though).

Anything would help!

Improve this question
2
  • 2
    Welcome to StackOverFlow. Please provide a minimal reproducible example like markdown tables containing your sample input data.
    – Gyul
    Commented Apr 16 at 21:54
  • Apps script cannot do this built in. There might be third party services like Twilio which maybe able to do this. If they can, you can connect with them through Apps script. if you're looking for something without Cloud, python may help.
    – TheMaster
    Commented Apr 17 at 1:35
Related questions
1
Creating a Log tab of sent data using Google Sheets Apps Script
25
Deleting rows in google sheets using Google Apps Script
2
Can Google Apps script make a phone call?
Load 2 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.