Autocrat emails not sending

299 views
Skip to first unread message

missionandministry missionandministry

unread,
Aug 28, 2024, 9:46:37 AM8/28/24
to NV Autocrat Add-on
Good morning, folks!

I've set up two jobs on a single spreadsheet. They run manually and on triggers and the documents are created without issue; however, none of the emails are sent. As far as I know, I'm formatting everything correctly.

I've seen some people recommend the following, but I have questions:
  • Reset time zone information: I've done this, but it has had no effect.
  • Uninstall and reinstall Autocrat: would I lose the jobs I've created?
  • Only be logged into a single Google Account, or work in an incognito window: I regularly am logged into multiple Chrome profiles at work and at home (out of necessity). How would it work to have a time trigger running in an incognito window? Do time triggers work only when Chrome is open and active?
Here's my user key: AD/S0yGIszMzX2tL7sIX+B4nD1oWOqDmWuNDlbPmDvmfGNF1zICEFDHUt3lvfhv9XZCmepq2yA//

Any suggestions?

Best,
Michael

Joseph Schmidt

unread,
Aug 28, 2024, 10:55:16 AM8/28/24
to nv-autocr...@googlegroups.com
What is in the status column that is added by Autocrat?  The 4th column.  




--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/0237bb8d-bcb1-4bd9-a2d8-85ab2ffde20bn%40googlegroups.com.

Office of Mission & Ministry

unread,
Aug 28, 2024, 4:15:26 PM8/28/24
to nv-autocr...@googlegroups.com
Thanks for tipping me off to that column!

It looks like one email actually went through:

Document successfully created; Document successfully merged; Emails Sent: [To: X...@georgetown.edu; CC:Y...@georgetown.edu; BCC: missionan...@georgetown.edu]; Manually run by missionan...@georgetown.edu; Timestamp: Aug 28 2024 3:56 PM

Meanwhile, several other emails did not, even though the email addresses listed are correct:

Document successfully created; Document successfully merged; Failed to add X...@georgetown.edu; Y...@georgetown.edu as editor: API call to drive.permissions.insert failed with error: Invalid permission value; !!Error Sending Emails: Invalid email: X...@georgetown.edu; Y...@georgetown.edu; Manually run by missionan...@georgetown.edu; Timestamp: Aug 28 2024 3:57 PM

You received this message because you are subscribed to a topic in the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/nv-autocrat-add-on/TfeJBg_w6PY/unsubscribe.
To unsubscribe from this group and all its topics, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTORscGpM-3SPbPVLZ1kESbX5ePuWfmX%3D_QQfzZ-H3RWxNg%40mail.gmail.com.


--

Office of Mission & Ministry

Georgetown University

108 Healy Hall

37th & O Streets NW

Washington, DC, 20057

Joseph Schmidt

unread,
Aug 28, 2024, 5:01:11 PM8/28/24
to nv-autocr...@googlegroups.com

missionandministry missionandministry

unread,
Aug 30, 2024, 2:40:23 PM8/30/24
to NV Autocrat Add-on
Ahhh, gotcha! I found guidance that said we needed to use semicolons or commas based on our country, but that's good to know! Thanks!

Justin Humphries

unread,
Sep 5, 2024, 10:50:37 AM9/5/24
to NV Autocrat Add-on
Everything works as intended, however the emails are not being sent.  The 4th column shows that the email was sent and there are no error messages, however I did not receive the email and neither did the intended recipient.  

Email correspondence to and from this address is subject to public records requests pursuant to the North Carolina Public Records Law, resulting in monitoring and potential disclosure of this message to third parties.

In compliance with federal law, Charlotte-Mecklenburg Schools administers all education programs, employment activities and admissions without discrimination against any person on the basis of gender, race, color, religion, national origin, age or disability.

Joseph Schmidt

unread,
Sep 5, 2024, 3:07:11 PM9/5/24
to nv-autocr...@googlegroups.com
I suspect a problem with the SPF records for the school domain.  That is above my pay grade but if you run the same merge under your personal Gmail account, the email will be sent.
--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages