I want to put local excel file to database (bigquery, mysql etc.)
So I will upload local excel in Softr(web builder) and this will trigger webhook in MAKE.
But I couldn’t find some function that I can read data from excel in MAKE.
And I don’t have the plan to use microsoft 365. How can I overcome this problem in MAKE?
Welcome to the Make community!
If the file (uploaded to your website), is publicly accessible via the internet,
-
You could use the HTTP “Get a file” module to download it, then
-
Use the Google Drive “Upload a file” module to get it on Google Drive, then
-
Use the Google Sheets “Search Rows” module to get all the data on the sheet.
I would suggest completing the Make Academy before jumping into building your first scenario.
If you need specific assistance when you are building a scenario it’s easier to help you then.
Otherwise, you can also hire a professional by posting in the #solution-exchange:professional-services category.
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
General
- Help Center | Tutorials
- Make Academy – learn Make and get your certificate
- Discord Server – join us in a community-run live chat
Help Center Basics
- Mapping – What is mapping? What can I map?
- Mapping with arrays – How to map items in an array
- Aggregate an array for mapping complex fields
- Tokens for
parseDate| Tokens forformatDate - HTTP modules – Make a request, Get (download) a file
- Webhooks – Error Handling, Responding to webhooks
Articles & Videos
- Router Magic Formula - YouTube
- Error Handlers in Make - YouTube playlist
- Getting started with OpenAI
- How to use Regex in Make
samliew – request private consultation
Join the unofficial Make Discord server to chat with other makers!
1 Like