About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Question

Find a worksheet in an Excel spreadsheet from data

Louvivien

Hello, 

I have some data extracted from a PDF File. My spreadsheet has different worsksheets. I want to create a new row in a specific worksheet based in the extracted data. Is it possible ?

Regards

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

ken.a
Userlevel 7
Badge +6

Hey there @Louvivien,

Welcome to the Community! 🎉

To make sure I fully get what you're aiming for, could you tell me a bit more about it? Like, what's the ultimate goal with this Zap you're setting up? It'd be super helpful if you could break it down step-by-step in a "When A happens in Service X, B should happen in Service Y" way. That'll make it easier for me to give you the best suggestion possible!

Thanks so much in advance, just want to make sure we're both on the same page. 😊

Louvivien

Hi thank you for your reply.
When I get a PDF in a google drive folder

I parse it with Parseur

When a new file is processed by Parseur

I want to create a new row with these data in an excel spreadsheet 

This spreadsheet has several worksheet and I need Zapier to find the relevant worksheet based on one of the parsed data. 

Thank you

Charie
Userlevel 3
Badge +4

Hi @Louvivien 

Thank you for confirming that information.

Here's what I think your Zap would look like:

  1. Trigger: "New File in Folder" in Google Drive
  2. Action: "Create Document From File" in Paseur
  3. Action: "Find Worksheet" in Google Sheets
  4. Action: "Create Spreadsheet Row" in Google Sheets

However, there are a few things you need to consider with this workflow.

  • This is a multiple-step Zap that would require you to upgrade your plan. See here for plan pricing and options.
  • The "Find Worksheet" step requires the "Title" of the worksheet that it will look for. That said, the document title from the "Parseur" step should match the worksheet title. Please see the screenshot for your reference.

Let me know if you have other questions.

Terms & Conditions