-
Notifications
You must be signed in to change notification settings - Fork 0
/
use.js
244 lines (241 loc) · 16.3 KB
/
use.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
export const customers = [
{
slug: "yetgen",
name: "Yetkin Gençler",
logo: "https://cdn.useefficiently.com/YetkinGencler.svg",
linkedin: "https://www.yetkingencler.com/",
title: `<h1 id="who-is-yetgen-">YetGen</h1>`,
metaTitle: "Yetkin Gençler",
description:
"Yetkin Gençler is a 14-week online educational program that currently attracts more than 10,000 applicants and engages 2,000 participants per cohort. Participant’s data on attendance, course completion are sourced from different platforms and turned in to meaningful insights on Airtable",
detail: `<p>YetGen is a 14-week online educational program that currently attracts more than 10,000 applicants and engages 2,000 participants per cohort. Participant’s data on attendance, course completion are sourced from different platforms and turned in to meaningful insights on Airtable</p>`,
},
{
slug: "publicsquare",
name: "PublicSquare",
logo: "https://cdn.useefficiently.com/PublicSquare.svg",
linkedin: "https://upwork.com/freelancers/ahmetkok",
title: `<h1 id="who-is-publicsquare-">PublicSquare</h1>`,
metaTitle: "PublicSquare",
description:
"PublicSquare is a private fintech company based in Brisbane, Australia. Since launching in November 2021, the company has attracted strong interest from customers and investors by making its products accessible to as many aspiring homebuyers as possible.",
detail: `<p>Founded by returning ex-pat and entrepreneur, Dean Arnold, PublicSquare is a private fintech company based in Brisbane, Australia. Since launching in November 2021, the company has attracted strong interest from customers and investors by making its products accessible to as many aspiring homebuyers as possible.</p>
<h2 id="our-collaboration-with-publicsquare">Our Collaboration with PublicSquare</h2>
<p>We’ve been working with the PublicSquare team since the beginning of 2024 to enhance their Airtable system. We continuously add new automations and regularly monitor them to ensure everything runs smoothly. To cut costs, we’re migrating automations to more budget-friendly platforms while keeping the system efficient.</p>
<h2 id="over-200-automations-in-action">Over 200 Automations in Action</h2>
<p>PublicSquare now runs more than 200 automations, processing at least 40,000 tasks each month. This automation has made PublicSquare a highly efficient technology user.</p>
<h2 id="key-automation-areas">Key Automation Areas</h2>
<h3 id="image-process-automations">Image Process Automations</h3>
<p>Streamlining the handling of image files for faster, more efficient workflows.</p>
<h3 id="sms-email-automations">SMS & Email Automations</h3>
<p>Automating communication with customers through seamless SMS and email campaigns.</p>
<h3 id="workflow-optimizations">Workflow Optimizations</h3>
<p>Enhancing internal processes to ensure a smoother, more effective workflow.</p>
`,
},
{
slug: "girvak",
name: "Turkiye Entrepreneurship Foundation",
logo: "https://cdn.useefficiently.com/TurkiyeEntrepreneurshipFoundation.svg",
linkedin: "https://www.girisimcilikvakfi.org/",
title: `<h1 id="who-is-girvak-">Turkiye Entrepreneurship Foundation</h1>`,
metaTitle: "Turkiye Entrepreneurship Foundation",
description:
"GIRVAK is the largest entrepreneurship foundation in Turkey, established by prominent businesspeople. Their main sponsor is Isbank, the wealthiest bank in the country. They initiate projects, provide education, and collaborate directly with Turkey’s legal authorities to foster an entrepreneurship culture in every aspect.",
detail: `<p><a href="https://www.girisimcilikvakfi.org/">GIRVAK</a> is the largest entrepreneurship foundation in Turkey, established by prominent businesspeople. Their main sponsor is <a href="https://www.isbank.com.tr/en">Isbank</a>, the wealthiest bank in the country. They initiate projects, provide education, and collaborate directly with Turkey’s legal authorities to foster an entrepreneurship culture in every aspect.</p>
<h2 id="what-do-we-do-for-them-">What do we do for them?</h2>
<h3 id="-republic-of-turkey-ministry-of-trade-cooperative-program-">Republic of Turkey Ministry of Trade - Cooperative Program</h3>
<p>We have built and manage the IT system for GIRVAK’s cooperative program, which they operate in conjunction with <a href="https://www.trade.gov.tr/">Turkey’s Ministry of Trade</a> using Airtable. This includes:</p>
<ul>
<li>Collecting cooperative data and applications, expected to reach 5000.</li>
<li>Sending tailored automated emails with API-integrated <a href="https://www.brevo.com/">Brevo</a> and <a href="https://airtable.com/developers/scripting">Airtable scripts</a>.</li>
<li>Creating a semi-automated email system that allows the team to send bulk emails again with Brevo from the Airtable admin interface at will.</li>
<li>Creating Airtable admin and visual interfaces for a two-step application process, allowing the coordinator to evaluate and interface with the data securely.</li>
</ul>
<h3 id="project-management-system-for-the-whole-girvak-team">Project Management System for the Whole GIRVAK Team</h3>
<p>This system is the ultimate project management tool for all organizational departments to manage their projects, tasks, activities, events, and team communications. The purpose of this general IT system is for the entire organization to use Airtable exclusively and manage all activities in one place. This also includes engaging with their applicants, jury, mentors, contacts, sponsors, and triggering automations like email sending.</p>
<h3 id="-young-talent-program-">Young Talent Program</h3>
<p>The Young Talent Program receives the most applicants, over 150,000 annually, for entrepreneurship education for university students. We manage its entire IT process using Airtable and integrated apps, which includes:</p>
<ul>
<li>A five-stage application process with unique validation conditions, managing and clearing all data, matching application stages optimally and securely. We also match ongoing applications with historical applicant data to scrape necessary information for the GIRVAK team and juries.</li>
<li>Creating three different evaluation interfaces for over 100 Airtable-editor-permissioned juries to evaluate applicants and decide on their advancement to the next stage.</li>
<li>Creating a fully automated Airtable system for juries to create availability, send calendar invites via <a href="https://zoom.us/">Zoom</a> or Google Calendar, and allow applicants to choose from available slots, adding them to the individual meetings of the juries.<ul>
<li>Implementing a calendar cancellation system for both juries and applicants.</li>
<li>Automating the process if two applicants choose the same slot within the same 10 seconds, moving one to another meeting at the same time with another jury if available; if not, informing the applicant to choose again. And many more detailed automations fully implemented in Airtable…</li>
</ul>
</li>
<li>Creating Airtable dashboards with necessary information for every stage.</li>
<li>Creating secure admin coordinator interfaces for the GIRVAK team to oversee and modify jury and applicant information, send bulk emails, reschedule meetings, and more.</li>
<li>Integrating Slack automation for team needs and tagging specific departments or people.</li>
</ul>
<h3 id="-google-game-and-app-development-academy-">Google Game and App Development Academy</h3>
<p>This is a Game and App Development Academy program operated in collaboration with Google. It involves a four-stage application process, with over 50,000 applications annually. We created the entire IT system and manage it during their program, which includes:</p>
<ul>
<li>Creating a four-stage application process with specific requirements.</li>
<li>Implementing both automated email sending using Brevo API and Airtable scripts, and a manual bulk email sending system for the team.</li>
<li>Creating Airtable dashboards and secure admin interfaces for the GIRVAK team to interface and visualize the data for their tailored needs.</li>
</ul>
`,
},
{
slug: "oihs",
name: "Ontario International High School",
logo: "https://cdn.useefficiently.com/OntarioInternationalHighSchool.png",
linkedin: "https://www.oihs.ca/",
title: ``,
metaTitle: "Ontario International High School",
description: "",
detail: ``,
},
{
slug: "gkp",
name: "Geleceğin Kooperatifleri",
logo: "https://cdn.useefficiently.com/GeleceginKooperatifleri.png",
linkedin: "https://www.girisimcilikvakfi.org/",
title: ``,
metaTitle: "Ontario International High School",
description: "",
detail: ``,
},
{
slug: "oua",
name: "Google Game and Application Academy",
logo: "https://cdn.useefficiently.com/GoogleGameandApplicationAcademy.svg",
linkedin: "https://www.yapayzekaveteknolojiakademisi.com/",
title: `<h1 id="google-game-and-app-development-academy">Google Game and App Development Academy</h1>`,
metaTitle: "Google Game and App Development Academy",
description:
"This is a Game and App Development Academy program operated in collaboration with Google. It involves a four-stage application process, with over 50,000 applications annually. We created the entire IT system and manage it during their program.",
detail: `<p>This is a Game and App Development Academy program operated in collaboration with Google. It involves a four-stage application process, with over 50,000 applications annually. We created the entire IT system and manage it during their program, which includes:</p>
<ul>
<li>Creating a four-stage application process with specific requirements.</li>
<li>Implementing both automated email sending using Brevo API and Airtable scripts, and a manual bulk email sending system for the team.</li>
<li>Creating Airtable dashboards and secure admin interfaces for the GIRVAK team to interface and visualize the data for their tailored needs.</li>
</ul>`,
},
];
export const testimonials = [
{
slug: "publicsquare",
name: "Dean Arnold",
title: "CEO, PublicSquare",
pic: "https://cdn.useefficiently.com/Dean-Arnold.jpeg",
span: "sm:col-span-1",
linkedin: "https://www.linkedin.com/in/deanarnold1/",
quote:
"<p>A+++. I was thoroughly impressed with the results of this project. It turned out to be far more complex than anticipated, requiring a significant amount of persistence and technical skill. Leo demonstrated exceptional proficiency as a full-stack developer, especially in working with APIs and developing intricate automations. His approach to testing, analysis, and selection of third-party services and APIs was both meticulous and strategic. Working with Leo was a genuinely positive experience, and we got the job done together where im sure other freelancers would have given up or started asking about additional fees and so on.</p>",
},
{
slug: "girvak",
name: "Selin Altuntecim",
title: "Coordinator, Turkiye Entrepreneurship Foundation",
pic: "https://cdn.useefficiently.com/Selin-Altuntecim.jpeg",
span: "sm:col-span-2",
linkedin: "https://www.linkedin.com/in/selin-altuntecim/",
quote: `<p>I’m extremely pleased with the services provided by our partner. Their expertise has been invaluable in streamlining our processes, enhancing efficiency and organization. They consistently demonstrate industry knowledge and offer innovative solutions tailored to our needs. Communication has been smooth, with prompt responses to adjustments or feedback, ensuring outcomes that align with our goals. I highly recommend them for their dedication to quality, reliability, and professionalism.</p>`,
},
{
slug: "yetgen",
name: "Erhan Erkut",
title: "Founder, Yetkin Gençler",
pic: "https://cdn.useefficiently.com/Erhan-Erkut.jpeg",
span: "sm:col-span-1",
linkedin: "https://www.linkedin.com/in/erhan-erkut/",
quote:
"<p>We worked with UseEfficiently for a long time and received high-quality service. Communication with the team was easy, and it was clear that they were experienced in their field.</p>",
},
];
export const useCases = [
{
title: "Human Resources",
description:
"<p>Tracking employee performance and managing training is easy with Airtable Forms and Airtable Automations. Forms for new hires and quick application evaluations simplify the process.</p>",
hoverEffect: "hover:-rotate-2 hover:scale-105",
},
{
title: "Project Management",
description:
"<p>Keeps projects on track with Airtable Interface and Airtable Automations, organizing tasks and team members, ensuring deadlines are met without stress.</p>",
hoverEffect: "hover:rotate-2 hover:scale-105",
},
{
title: "Community Management",
description:
"<p>Organizing the community is simple with Airtable Interface and Airtable Filters. Member info stays tidy, and events and campaigns are efficiently planned.</p>",
hoverEffect: "hover:rotate-2 hover:scale-105",
},
{
title: "Marketing",
description:
"<p>Marketing campaigns are easily tracked with Airtable Interface and Airtable Dashboards. Performance is analyzed, customer relationships improve, and better strategies are developed.</p>",
hoverEffect: "hover:-rotate-2 hover:scale-105",
},
{
title: "Sales Management",
description:
"<p>The sales process runs smoothly with Airtable Forms and Airtable Automations. Customer info is stored, interactions are tracked, and sales goals are hit quickly.</p>",
hoverEffect: "hover:rotate-2 hover:scale-105",
},
{
title: "Education Management",
description:
"<p>Educational programs are easily planned with Airtable Interface and Airtable Automations. Student progress is tracked, and course content is updated as needed.</p>",
hoverEffect: "hover:-rotate-2 hover:scale-105",
},
{
title: "Event Planning",
description:
"<p>Plan and manage events effortlessly with Airtable Interface and Airtable Forms. Keep track of RSVPs, schedules, and logistics in one place.</p>",
hoverEffect: "hover:rotate-2 hover:scale-105",
},
{
title: "Inventory Management",
description:
"<p>Monitor and manage inventory levels with Airtable Interface and Airtable Automations. Track stock levels, orders, and deliveries efficiently.</p>",
hoverEffect: "hover:-rotate-2 hover:scale-105",
},
{
title: "Finance Tracking",
description:
"<p>Manage budgets and track expenses with Airtable Interface and Airtable Dashboards. Get insights into your financial data quickly and easily.</p>",
hoverEffect: "hover:rotate-2 hover:scale-105",
},
];
export const team = [
{
name: "Leo Kök",
title: "Software Developer",
address: "Istanbul, Turkiye",
quote:
"Leo is all about making things work better. With a deep understanding of Airtable, he’s transformed how businesses handle their workflows. He loves seeing others succeed and often shares his expertise with the community, turning complex tasks into simple, efficient processes.",
pic: "https://cdn.useefficiently.com/leo.jpeg",
linkedin: "https://www.linkedin.com/in/ahmet-kok/",
},
{
name: "Nate Dogan",
title: "Airtable Consultant",
address: "Ontario, Canada",
quote:
"Nate, as a tech lead, has spent over 5 years guiding teams to build custom solutions without a single line of code. His focus is on finding the smartest, most efficient ways to tackle problems. Nate takes pride in creating seamless systems that make work easier for everyone involved.",
pic: "https://cdn.useefficiently.com/nate.jpeg",
linkedin: "https://www.linkedin.com/in/nusretdogan/",
},
{
name: "Lukas Kaiser",
title: "Airtable Consultant",
address: "Clausthal, Germany",
quote:
"Lukas started exploring no-code tools over 3 years ago when he saw the potential to empower businesses to create without coding. He’s passionate about helping others realize that they don’t need to be developers to build something amazing. Lukas enjoys teaching others how to unlock the full potential of no-code.",
pic: "https://cdn.useefficiently.com/lukas.jpeg",
linkedin: "https://www.linkedin.com/in/lukas-kaiser-lk/",
},
{
name: "Yunus Şen",
title: "Solution Consultant",
address: "Istanbul, Turkiye",
quote:
"",
pic: "https://cdn.useefficiently.com/yunus.jpeg",
linkedin: "https://www.linkedin.com/in/yunuseshen/",
},
];