Skip to main content
Question

How do I bulk import 1300 Outlook contacts to Notion in my Zap?

  • December 28, 2023
  • 14 replies
  • 80 views

Hi, I am looking for the optimum combination of Apps to do the following:

New email comes into outlook, it gets converted to PDF (with the same look as if you just printed it from your screen, with header and footer and all details etc.), gets saved into OneDrive folder with our specific filing format (YEAR_MonthDate Name - Subject). Any ideas how i can achieve this goal?

ps: I would also want to document my emails that are sent out as well, is there a way to achieve that result as well (or possibly even in the same Zap)?

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

14 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • December 29, 2023

Hi @KLF 

Good question.

FYI: Gmail has better trigger options (that include sent emails) than Outlook.

 

Yes, this is possible, as I’ve done a similar project for a client.

 

One such Zap app is PDF.co: https://zapier.com/apps/pdfco/integrations#triggers-and-actions

 

If you need help, consider hiring a Certified Zapier Expert.


  • Author
  • Beginner
  • January 2, 2024

Thanks. I am using outlook unfortunately. I hires someone with Zapier but it didn't save key info like who sent to who, date, subject, formatting was off too. Could you do it with Microsoft small business outlook?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • January 2, 2024

@KLF 

Is the Email Body in HTML formater returned from the Outlook trigger step?


  • Author
  • Beginner
  • January 2, 2024

How would I know or find out? Is there something in the zaps which I could look at and tell you?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • January 2, 2024

@KLF 

Post screenshots of the DATA OUT from the Outlook Trigger step as it relates to the email body.

Look for HTML tags e.g. <br/> which is a line break, etc.,


  • Author
  • Beginner
  • January 3, 2024

Hi Troy, it looks like it is (see screenshots below)


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • January 3, 2024

@KLF 

Yes, the email body content type is HTML.

 


  • Author
  • Beginner
  • January 3, 2024

Great, so this is possible to create?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • January 3, 2024

@KLF 

Yes, this is possible, as I’ve done a similar project for a client.

One such Zap app is PDF.co: https://zapier.com/apps/pdfco/integrations#triggers-and-actions

If you need help, consider hiring a Certified Zapier Expert.

 

 


  • Author
  • Beginner
  • January 3, 2024

If I am unable to do it myself (will try now), can I hire you as my expert?

Thanks so much for all the help so far!

 


  • Author
  • Beginner
  • January 3, 2024

As well, I want to create a filter that only certain email addresses will get save when those people email me, how do I tell the Zap to reference a spreadsheet?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • January 3, 2024

Hi @KLF 

Which spreadsheet app are you using? (e.g. Gmail, Excel, etc.)


  • Author
  • Beginner
  • January 3, 2024

a Google Sheet


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • January 3, 2024

@KLF

Try these Zap action steps:

 

GSheets Zap available triggers/actions: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions

Help articles to reference for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

 

Filter: https://zapier.com/app/get-help