Etsy - Gmail - Dropshipping Order Fulfillment Automation

Beginner Questions
1

:bullseye: What is your goal?

Hello, I need help making an automation that begins when I receive a shipping notification email to my Gmail inbox. (It is a shipping notification of products that I am dropshipping to my customers to fill Etsy orders) The email is read automatically. The key components of the email are the shipping address and the tracking number. It automatically takes the tracking number and completes the corresponding order in my Etsy shop by matching the shipping name and address.

I need it to start doing this for any new emails I recieve and the emails should be marked as read once they are processed this way.

:thinking: What is the problem?

I need some very detailed instructions, possibly with screenshots or details for how to fill out every field.

:test_tube: What have you tried so far?

I have already linked my Etsy and Gmail in Make, I just need to know how to fill out all the fields

3

Hey Grace,

Can you share some screenshots of the scenario so far and what you are struggling with?

Should be a straightforward Custom Mail hook → Text Parser → Etsy.

1 Like
4

Hi Grace. Welcome to the Community!

If you’re also able to provide an example of the shipping notification email that would be a big help - though do be sure to anonymize any personal details before posting!

5

Thank you for your reply. I appreciate it!

Here is the example shipping notification email with the 3 sections of data that need to be extracted:

  1. Shipping Name
  2. Shipping address
  3. Tracking number.

example email.pdf (933.1 KB)

in the scenerio builder for the first step, I have the Gmail “watch email” bubble and have added the info such as the sender email address, email subject etc.

The second module I added is the “text parser match pattern”. I am not sure what to put for the pattern:

image
image1231Ă—857 81.6 KB

6

You can use regex101.com to build your pattern.

You can also use it to share what you have and what you are struggling with if you need more help.

7

Ok thank you. This is above my knowledge level, so I’m not sure if I will be able to continue.

8

I’m chatting with someone at regex and I will see what I come up with.

9

Does Make support this syntax?

image
image1296Ă—161 16.2 KB

10

Yes,

you can also paste a sample email in regex101.com and share it here, then we can help build the regex you need to match whatever you are looking to extract.

11

Ok, here is the regex link: regex101: build, test, and debug regex

1 Like
12

Yeah that sounds correct. It should work in the Match Pattern module.
Just make sure you turn Global Match ON so it finds both and then use an array aggregator with the Match Pattern as the source module to go back to one bundle. Then the first item of the array will be the first match (with the name and the address) and the second item will be the tracking number. You can use their order index to map them directly, or use the get() function.

13

Welcome to the Make community!

You can use a Text Parser “Match Pattern” module with the regular expression pattern below.

Pattern [1]

Shipping Address\s+(?<name>.+)\n+(?<address>.+)\n+(?<address2>.+)\n+Shipping Method\n+(?<shipping_method>.+)\n+Shipping Company\n+(?<shipping_company>.+)\n+Tracking Number\n+(?<tracking_num>.+)(?=\n)

Take note! Global match must be set to NO :warning:

global-match

Output

361Ă—464 19.4 KB

For more information, see the Text Parser page in the Make Help Center:

Match Pattern
The Match pattern module enables you to find and extract string elements matching a search pattern from a given text. The search pattern is a regular expression, which is a sequence of characters in which each character is either a metacharacter, having a special meaning, or a regular character that has a literal meaning.

— @samliew

  1. Proof: Regex101—iWgClo/1 ↩︎

1 Like
14

Thank you for this info! What is the next module I should add after the text parser?

15

Wherever you need the data to go to of course!

I would suggest completing the Make Academy before jumping into building a complete scenario. If you need specific assistance when you are building a scenario it’s easier to help you then.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Learn Make

How-Tos

Useful to Know

My Custom App — Absolutely Free!

Save development time and operation credits with these utility modules: Chunk Text; Chunk Array; Chunk Words; Multiple Find & Replace; Collection to Array/String List; Execute JavaScript; Estimate Tokens; Calculate Difference Between Two Dates; Get Next Business Day (with holidays); List Upcoming Dates of Day of Week; and more!

— @samliew