Skip to main content
Best answer

How to format address fields from Kajabi to include spaces in Google Sheets?


Aloha, 

 

I am working with the platform Kajabi and Google Sheets. 

 

I want to format the address information from Kajabi checkout (address, state, zipcode, etc) so that there are spaces when they are zapped into the google sheets. 

This is the Kajabi check-out screenshot attached mahalo!

 

When address is zapped into google sheet I see: addresscitystatezipcode

I want it to look like address city state zipcode

 

Best answer by SamBBest answer by SamB

Hey @Aleysia

Troy’s correct here, it’s not necessary to use a Formatter step to add the spaces in between each Kajabi address field. You can select the individual fields from the Kajabi directly in your Google Sheets step.

Depending on how you have your Google Sheets spreadsheet set up you can either select the individual address fields for each column. Or if you’re using a single column in Google Sheets to store the address, then you’d select all the individual Kajabi address fields but manually type in a “space” in between each field. Here’s a couple of examples of how those different set ups would look to help explain it better...

For separate address columns in Google Sheets:
9d96debd4a0b8c6eacfdc1e35cb164ae.png

For a single address column in Google Sheets:
63c403c667cea267665577acae4797e8.png

Hope that helps! :relaxed:

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @Aleysia 

Please post screenshots with how your Zap step is configured.

TIP: Try adding a space between the mapped variables for each data point, then test.


  • Author
  • Beginner
  • 5 replies
  • February 10, 2022

Super helpful mahalo!

 

I got confused between the 2 options if you could articulate the difference between the transform and the separator options. 

 

 


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31416 replies
  • February 11, 2022

@Aleysia 

You shouldn’t need a Formatter step in your Zap.

Simply map each data point to the desired GSheet fields. (assuming you have a separate field for each Address part, which would be advised)

 

If you want a properly formatted Address in 1 line then, make sure to add a space between each mapped variable.



NOTE: You are missing Address Line 2

 

Also, the trigger example you are using to configure the Zap has “No data” for each mapped variable.

Help article for how to change the trigger test data: https://zapier.com/help/create/basics/change-the-test-data-in-your-zap-trigger


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7811 replies
  • Answer
  • February 11, 2022

Hey @Aleysia

Troy’s correct here, it’s not necessary to use a Formatter step to add the spaces in between each Kajabi address field. You can select the individual fields from the Kajabi directly in your Google Sheets step.

Depending on how you have your Google Sheets spreadsheet set up you can either select the individual address fields for each column. Or if you’re using a single column in Google Sheets to store the address, then you’d select all the individual Kajabi address fields but manually type in a “space” in between each field. Here’s a couple of examples of how those different set ups would look to help explain it better...

For separate address columns in Google Sheets:
9d96debd4a0b8c6eacfdc1e35cb164ae.png

For a single address column in Google Sheets:
63c403c667cea267665577acae4797e8.png

Hope that helps! :relaxed:


  • Author
  • Beginner
  • 5 replies
  • February 16, 2022

Thank you for the screenshots for reference. I did my zaps again with simply adding the spaces and it worked! Mahalo!