Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hello All,

We are using our discord for racing in a video game. Our users will race and when they are done they are asked to post in a format similar to below

What we are hoping to do is to have this information input into google sheets for us:

Currently I am unable to see a way for Zapier to see the difference of what information goes into what cells?

Name/Team:(output to Column A) puckvirus121 
Track:(output to Column B) Ambleside 
Class:(output to Column C) kit car
Season:(output to Column D) Summer
Time:(output to Column E) 2:42.9
Car:(output to Column F) 1993 Renault Clio williams

Would it be possible for Zapier to be able told to look for specific symbols within a message to tell it to start filling the next column? For example using | / \ ; ! 

Hi @puckvirus121! The first thing that comes to mind is that you could use the Formatter to do this. You could, of course, use code if you’re familiar with how to do that. Digging into that goes beyond the scope of what we can provide but here’s how I would accomplish it with Formatter.

  1. Trigger: Discord
  2. Action: Formatter — Split Text — take the Content field, separate by :newline:] and segment into line items
  3. Action: Formatter — Split Text — take the output of the previous step, separate by :  (note that there’s a space typed after the colon) and output the “last” segment
  4. Action: Formatter — Utilities — Line Item to Text (this then gives you just the sections you want, each as separate fields you can map to Google Sheets
  5. Action: Google Sheets

2) Formatter — Split Text 

 

 

3) Formatter — Split Text 

 

4) Formatter — Utilities — Line Item to Text

 

 

5) Google Sheets

 

 

Hope that helps to clarify what I meant with my initial instructions :)

Terms & Conditions