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 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!