Questions about PDF + Google Sheets integration

This topic was automatically generated from Slack. You can find the original thread here.

Jane Fincham : Hello everyone - I am a complete beginner (just starting to learn nodejs) and would like to eventually be able to create my first basic workflow to take an emailed pdf which creates a googlesheet to connect to Shopify and delete products. Thank you for your time and patience with my question - I am so far behind on this and will catch up soon.

Sergio Rodriguez : Hi Jane, welcome to Pipedream. Sorry, what is you question specifically? I can notice you sort of outlined the purpose, or requirement for your workflow

Raymond Camden : if part of the issue is, ‘get tabular data from the pdf’, i can help with that - I work at Adobe and we’ve got a (commercial - fyi) API for that and it works fine w/ Pipedream.

Jane Fincham : Oh, thank you, that would be very helpful! How do I go about organising it?

Raymond Camden : Extract (the part of our API that does that) is in private testing now. if you are ok using the beta, you can ping me and i can try to get you access

Raymond Camden : the rest of the API is publicly available of course and ive used it in PD well

Jane Fincham : Oh gosh, Raymond - I am such a beginner that I am worried I would seriously mess it up! I will see if I can use the publicly available API to try and get the numbers from the pdf and transfer them to a googlesheet. (We’re a small bookstore and have been trying to make our system more efficient instead of hand-typing millions of 13 digit ISBN’s in our sleep.)

Raymond Camden : ouch! that does sound painful.

Raymond Camden : if you would like to try the API, you can DM me. as i said though its commercial, i dont want to be too pushy :wink:

Jane Fincham : Yes, please - just trying to figure out where the dm button is…

Jane Fincham : Think I’ve found it!

Dominik Fischer : So happy that you have chosen to use software instead of typing it by hand :+1: What format does the PDF have? Is it already a list of ISBNs/Titles or is it a book pdf from which you want to extract title / isbn?