Page MenuHomePhabricator
Create Task
Maniphest T399743

Zendesk Spreadsheets Automation
Closed, ResolvedPublic
Actions

Description

Currently data is manually copied from Zendesk into a Google spreadsheet. We would like to automate this process, most likely with a script or using the Zendesk API. There is a Zendesk plugin for Google Spreadsheets which we could also investigate using.

Related Objects

Event Timeline

Mstyles created this task.Jul 16 2025, 5:16 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 16 2025, 5:16 PM
mmartorana moved this task from Backlog to In Progress on the FY2025-26 WE4.6.1 Support Desk Streamlining board.Jul 30 2025, 3:01 PM
jrbs added a comment.Sep 8 2025, 9:13 PM

The Connector seems to work for this, but it's quite slow. It should suffice for what we want here unless we can leverage the API at the same time (i.e. while solving T404009: Use Zendesk API to get requester emails into the spreadsheet.

jrbs closed this task as Resolved.Sep 29 2025, 3:40 AM
jrbs claimed this task.
jrbs added a subscriber: mmartorana.

I have basically resolved this with an Apps Script function. We can focus on T399742

mmartorana moved this task from In Progress to Done on the FY2025-26 WE4.6.1 Support Desk Streamlining board.Nov 10 2025, 4:03 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits