Gmail > Attachment > xlsx > MySQL

[Perry_Bosman]

I want to retrieve an excel spreadsheet from a gmail attachment and store the spreadsheet rows in a MySQL table. Need some help achieving this

I am stuck at the point that I need to pick-up the xlsx file and do field mapping to the MySQL table. MySQL connection is working.

Thanks for your concern.

[Olly_Ats]

Hey @Perry_Bosman

From your description, I believe you would need a conversion app like Cloudconvert and your scenario would be set up this way:

The ‘CloudConvert’ module:

The ‘Parse CSV’ module, you would need to specify the number of columns in the xlsx/csv file:

Then after a test run, you should be able to have mappable values to insert into the MySQL module.

I hope this helps you.

[Perry_Bosman]

Thanks Olly, Would have never found that myself. What happens now that CloudConvert picks up an image001.jpg that is not in the attachment but in the email body

. The attachment is a xlsx file.

Can you think of a way to only pick up the xlsx?

I tested with an email where I removed all the body content and then it worked!!

This is my CloudConvert setup:

[Perry_Bosman]

@Olly_Ats Hey Olly I would be very thankful if you could take one more look at the provided solution. The problem that CloudConvert picks up an image from the email body instead of the xlsx attachment.

Thanks for your concern

[CodexSolutions]

Hi @Perry_Bosman
I have a workaround that I did and posted on showcase as well.🚀 Integrated Lead Management Automation: Make, Phantom Buster, Google Drive, Google Sheets, Zero Bounce, and HubSpot CRM 🚀
Upload a file directly into a Google drive and then it will automatically upload as a sheet and then you can use serach record module to run for each row in a sheet

[Olly_Ats]

Hey @Perry_Bosman

You can add a filter before the CloudConvert module, like this:

This would filter out all other files except the ones that contain “xlsx” extension in their name.