Data stopped transferring from Google Form to Sheet through Autocrat

[Erin Cheatham]

We have a Google Form set up to create a PDF and it just stopped working and I am not sure why. I inherited this form through my school's PTA so I was not the one that created it and I am having trouble troubleshooting what might have went wrong.

[Joseph Schmidt]

Does it create a file and not email or not run at all?  Is there anything in the status(4th) column?

Did the person who set up the merge turn off the trigger under their account and did you turn on the trigger?

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

On Fri, Oct 24, 2025 at 2:21 PM Erin Cheatham <erin.c...@gmail.com> wrote:

We have a Google Form set up to create a PDF and it just stopped working and I am not sure why. I inherited this form through my school's PTA so I was not the one that created it and I am having trouble troubleshooting what might have went wrong.

--
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 visit https://groups.google.com/d/msgid/nv-autocrat-add-on/1e7c96a2-1f69-4ad6-a22a-3b4a39be2d98n%40googlegroups.com.

[Erin Cheatham]

I already typed a response, but it's not showing up on here. 

[Joseph Schmidt]

I don't see a response.  If you would like to do a Zoom or Meet, let me know the times you are available.

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/e7af4fda-14c9-45d9-ad0d-917fb7e6884bn%40googlegroups.com.

[Erin Cheatham]

So, basically, the person that created it is not with the PTA anymore -- we have been using it for a couple years without problem. To answer your question, I think it doesn't run at all. We have a google excel document -- the first tab is information directly from the Google Form, the second tab was, I believe, the output from the Autocrat because it had the link to the pdf that was created based on the Form inputs. The problem was seen recently because the first tab had received 9 entries from the Google From, however, the second tab was missing those last 9 entries and the email that normally gets sent was also not sent on those last 9 entries. Is there a way to trouble shoot the error?

I'd be happy to share the document with you to see if you can see where the issue lies.

Thanks!

Erin

[Joseph Schmidt]

Can you run autocrat manually?

When it last ran did send from the correct email address?

There should be 4 columns that autocrat added.  The 4th column contains the status of the merge.

Look at the last row that processed and check if it sent using the correct email.

If it was still sending with the previous email, you will likely need to create a new output sheet from the Google form into a new Google spreadsheet.

Google has spreadsheets and Microsoft has Excel 

Joe Schmidt

To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/78a16588-ef5c-4776-9ff6-068878f07a2fn%40googlegroups.com.