JOTFORM + Google Sheet Lookup = Pipedrive Lead

This definitely sounds like something Zapier would be perfect for!

Is the zip code in its own field coming out of Jotform? if not, you will need to use some type of Formatter action to retrieve the zip code. Sharing a screenshot of how the data comes from Jotform would help me assist a little further in regards to this. 

Once you have the zip code isolated in its own field, you can use it in a google sheets action “Lookup Spreadsheet Row” searching the column that contains the zip code. 

From there, you can output to Pipedrive and assign the sales person. *it may be helpful to include the sales persons Pipedrive ID as opposed to just a name. 

Hi @RobertNagel!

It would be helpful to see an example of the type of URL that’s coming through Jotform, and then which part of that URL you’re trying to isolate. 

Also, what does it look like when multiple URLs come through? You can use Formatter by Zapier to split text and also to convert line items to text (and vice versa). But without having a solid idea of how your data is coming through, it’s difficult for anyone to guide you.

Thanks!

Hi @RobertNagel 

A code block would be a good solution for this. Try using a code block and javascript but insert your links using input from a previous step as opposed to pasting them in like you see below. 
 

let regex = /(?<=form_files\/)(.*)(?=\.[0-9])/g;
const matches = inputData.links.match(regex)

var output = [];

matches.forEach(match => {
  output.push(match.substring(0,match.indexOf(".")));
})


return {
  output: output
}

Hi Robert! 

I am not quite sure what you are asking but would always be happy to support you in any of your Zapier needs

The above code provided should split your links into a list with these values “buche rustikal, kiefer”. Feel free to use it and let me know your results!

Hi @RobertNagel!

What @GetUWired showed above would be done using a Code step like this:

You wouldn’t necessarily need a developer, since he’s been kind enough to offer the code as well. Instead of the static text he showed, you’d map it from your trigger step by clicking into this field (my trigger is a test app, but you would see JotForm instead):

He also provided a link to his Zapier Experts directory listing, since you mentioned hiring someone.