Upgrade StorageZotero SOS: Google Forms + Sheets Integration Nightmare
Hello, Zotero community!
I'm at my wit's end. I've been struggling for days to integrate Google Forms and Google Sheets with Zotero via Apps Script, but to no avail.
Goal:
Collect Zotero article links through Google Forms.
Automatically extract article metadata from Zotero.
Write this data into Google Sheets, categorizing it based on form responses.
Problem:
The script seems to be running, but the data doesn't appear in Google Sheets. I've checked the logs, there are no errors, but no results either.
My code (simplified):
Google Sheets:
https://s3.amazonaws.com/zotero.org/images/forums/u14240183/ovww33b35e94ogxxr5o0.png
Google Forms:
https://s3.amazonaws.com/zotero.org/images/forums/u14240183/vdv2nqdqaael74wc8x76.png
Question:
Has anyone else encountered a similar problem? Or are there any Apps Script and Zotero experts willing to help me figure this out?
I would be grateful for any help!
I'm at my wit's end. I've been struggling for days to integrate Google Forms and Google Sheets with Zotero via Apps Script, but to no avail.
Goal:
Collect Zotero article links through Google Forms.
Automatically extract article metadata from Zotero.
Write this data into Google Sheets, categorizing it based on form responses.
Problem:
The script seems to be running, but the data doesn't appear in Google Sheets. I've checked the logs, there are no errors, but no results either.
My code (simplified):
Google Sheets:
https://s3.amazonaws.com/zotero.org/images/forums/u14240183/ovww33b35e94ogxxr5o0.png
Google Forms:
https://s3.amazonaws.com/zotero.org/images/forums/u14240183/vdv2nqdqaael74wc8x76.png
Question:
Has anyone else encountered a similar problem? Or are there any Apps Script and Zotero experts willing to help me figure this out?
I would be grateful for any help!
Otherwise, the Zotero part of the code looks OK.