Moving rows from a spreadsheet into a project tracker is exactly the kind of work nobody should be doing by hand. In this demo, Claude Code reads a Google Sheet and creates Jira tickets from it — the result is visible first: new tickets already sitting on the board, formatted exactly as the team needs them, with the payload structured as JSON in the description.
The setup is deliberately simple. One data source, one instruction. A spreadsheet has been made with a list of work items, and the goal is to get all of them into Jira so the team can start executing on them. Rather than copying and pasting each row, you ask an agent to do it: look at my Google Sheets, put them in my Jira.
What an agent actually is
This demo is a clean illustration of what an agent is: it can read into one system and write into another. The back-and-forth of pulling data out of a sheet, reformatting it, and pushing it into a tracker is intellectual drudgery that people do every day — and it's exactly what an agent takes over. Once everything is hooked up, the instruction is a sentence, not a script.
Closing the loop in Slack
The flow doesn't stop at creating tickets. The same instruction tells the agent to message Laura in Slack to let her know what it did. That confirmation lands in the team's channel, so everyone knows the tickets are there and nobody duplicates the work. It's coordination built into the workflow itself.
Where this fits in the team's workflow
The tickets this creates feed into a social media flow tool the team uses to see what's being worked on, and to plan, record and distribute content quickly. To run that pipeline as a coordinated team, the work has to be checked out of a shared board — which is why getting everything into Jira matters. The task split here: one person integrating the flow into the tool, while Laura takes the full list and writes a Python script with Claude Code to get it into Jira.
This is the new way to work with information, and it's why agents are such a big deal. A follow-up video will cover integrating with the stream recorder buffer.
Transcript
This is a quick demo of using claude code to move data between spreadsheets and jira. So what you can see here is you have a, uh, JIRA ticket here, uh, with this information in and in the description you can see it's formatted like this, ah, at a JSON. And so uh, there's two in here. And what we did is we have this spreadsheet, ah, that's been made and we want to get all these into JIRA so we can start executing on them. Um, because what we're going to be doing is we're going to be integrating uh, JIRA with our uh, social media flow, uh, tool that we've made here. And this, uh, so this tool allows me to, you know, see what you're doing, uh, right now. It, you know, allows me to plan, uh, record and distribute, uh, very quickly. Um, but we have to be as a coordinated team, we have to check these out. We have a lot of things to make. So. So uh, this is uh, kind of the approach that we're doing here. Um, and so I'm doing one part. I'm integrating it into social flow. And um, Laura is going to take this entire list and write a Python script to, with cloud code to get it into jira. But I need some data to work with. Um, and so really this is what we do in cloud code. When you have everything hooked up into cloud cloud, uh, you can say, okay, look at the, my Google sheets, uh, put it in my Jira, uh, uh, and then message Laura in Slack to let her know that what you uh, did right, this is how to use agents. This is what an agent is. It can read into one system and it can write into another. And that's a lot of intellectual drudgery that people do. And so you can see how quickly I did this. Um, I think the message went, uh, yep, okay, here. And then, uh, here it is in uh, slack here, let's just. Oh, I gotta adjust that zoom. Uh, let's see here, let me see. Can I get a better zoom? Oh yeah, there we go. Oh, where's. There we go. Okay. So yeah, that's, that's social flow, that I'm just adjusting that zoom. So Laura gets the uh, message there, uh, to make sure that, hey, we're not stepping on each other's toes and we're communicating better as a team. So you can see how this is the new way to work with information. This is why agents are such a big deal.
Frequently Asked Questions
It reads from Google Sheets and writes into Jira, and in this demo it also posts a confirmation message to Slack so the team knows the work was done.
One: a spreadsheet with the list of work items. The instruction is simply to look at the Google Sheet, put it into Jira, and message Laura in Slack to confirm.
Each ticket carries the source information in the description, formatted as JSON, so the data is structured for downstream tooling.